Pandas Profiling Report

Dataset statistics

Number of variables	64
Number of observations	6087
Missing cells	33479
Missing cells (%)	8.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.0 MiB
Average record size in memory	520.0 B

Variable types

Numeric	13
Categorical	24
DateTime	2
Boolean	25

Alerts

`asset_backed` has constant value ""	Constant
`oid` has constant value ""	Constant
`slob` has constant value ""	Constant
`issue_offered_global` has constant value ""	Constant
`unit_deal` has constant value ""	Constant
`form_of_own` has constant value ""	Constant
`bond_type` has constant value ""	Constant
`greater_of` has constant value ""	Constant
`lesser_of` has constant value ""	Constant
`prospectus_issuer_name` has a high cardinality: 1069 distinct values	High cardinality
`issuer_cusip` has a high cardinality: 1078 distinct values	High cardinality
`issue_cusip` has a high cardinality: 1471 distinct values	High cardinality
`issue_name` has a high cardinality: 227 distinct values	High cardinality
`delivery_date` has a high cardinality: 1744 distinct values	High cardinality
`isin` has a high cardinality: 6080 distinct values	High cardinality
`complete_cusip` has a high cardinality: 6087 distinct values	High cardinality
`effective_date` has a high cardinality: 1767 distinct values	High cardinality
`dated_date` has a high cardinality: 1761 distinct values	High cardinality
`first_interest_date` has a high cardinality: 1583 distinct values	High cardinality
`last_interest_date` has a high cardinality: 2515 distinct values	High cardinality
`issue_id` is highly overall correlated with `amount_outstanding` and 3 other fields	High correlation
`gross_spread` is highly overall correlated with `selling_concession` and 3 other fields	High correlation
`selling_concession` is highly overall correlated with `gross_spread` and 3 other fields	High correlation
`offering_price` is highly overall correlated with `comp_neg_exch_deal` and 1 other fields	High correlation
`offering_yield` is highly overall correlated with `gross_spread` and 3 other fields	High correlation
`principal_amt` is highly overall correlated with `subsequent_data` and 2 other fields	High correlation
`action_price` is highly overall correlated with `mtn` and 6 other fields	High correlation
`action_amount` is highly overall correlated with `mtn` and 4 other fields	High correlation
`amount_outstanding` is highly overall correlated with `issue_id`	High correlation
`coupon` is highly overall correlated with `gross_spread` and 2 other fields	High correlation
`years_to_maturity` is highly overall correlated with `gross_spread` and 2 other fields	High correlation
`coupon_type` is highly overall correlated with `interest_frequency` and 2 other fields	High correlation
`mtn` is highly overall correlated with `action_price` and 4 other fields	High correlation
`yankee` is highly overall correlated with `sec_reg_type1` and 1 other fields	High correlation
`canadian` is highly overall correlated with `sec_reg_type1`	High correlation
`comp_neg_exch_deal` is highly overall correlated with `offering_price` and 2 other fields	High correlation
`rule_415_reg` is highly overall correlated with `issue_id`	High correlation
`sec_reg_type1` is highly overall correlated with `offering_price` and 3 other fields	High correlation
`denomination` is highly overall correlated with `yankee`	High correlation
`defeased` is highly overall correlated with `action_price` and 4 other fields	High correlation
`defaulted` is highly overall correlated with `action_price` and 2 other fields	High correlation
`tender_exch_offer` is highly overall correlated with `action_type`	High correlation
`refund_protection` is highly overall correlated with `action_price` and 4 other fields	High correlation
`overallotment_opt` is highly overall correlated with `selling_concession` and 2 other fields	High correlation
`active_issue` is highly overall correlated with `issue_id` and 2 other fields	High correlation
`subsequent_data` is highly overall correlated with `principal_amt` and 4 other fields	High correlation
`action_type` is highly overall correlated with `tender_exch_offer` and 2 other fields	High correlation
`see_note` is highly overall correlated with `offering_yield` and 8 other fields	High correlation
`interest_frequency` is highly overall correlated with `coupon_type` and 2 other fields	High correlation
`pay_in_kind` is highly overall correlated with `issue_id` and 7 other fields	High correlation
`coupon_change_indicator` is highly overall correlated with `coupon_type` and 2 other fields	High correlation
`day_count_basis` is highly overall correlated with `coupon_type` and 2 other fields	High correlation
`issue_name` is highly imbalanced (59.8%)	Imbalance
`security_level` is highly imbalanced (88.6%)	Imbalance
`mtn` is highly imbalanced (99.6%)	Imbalance
`canadian` is highly imbalanced (86.0%)	Imbalance
`settlement_type` is highly imbalanced (98.9%)	Imbalance
`comp_neg_exch_deal` is highly imbalanced (71.7%)	Imbalance
`sec_reg_type1` is highly imbalanced (54.1%)	Imbalance
`denomination` is highly imbalanced (71.7%)	Imbalance
`covenants` is highly imbalanced (81.5%)	Imbalance
`defeased` is highly imbalanced (99.8%)	Imbalance
`defaulted` is highly imbalanced (99.8%)	Imbalance
`redeemable` is highly imbalanced (52.3%)	Imbalance
`refund_protection` is highly imbalanced (99.8%)	Imbalance
`overallotment_opt` is highly imbalanced (99.4%)	Imbalance
`announced_call` is highly imbalanced (95.8%)	Imbalance
`dep_eligibility` is highly imbalanced (94.6%)	Imbalance
`see_note` is highly imbalanced (98.6%)	Imbalance
`interest_frequency` is highly imbalanced (79.1%)	Imbalance
`pay_in_kind` is highly imbalanced (99.6%)	Imbalance
`coupon_change_indicator` is highly imbalanced (72.4%)	Imbalance
`day_count_basis` is highly imbalanced (59.3%)	Imbalance
`gross_spread` has 348 (5.7%) missing values	Missing
`selling_concession` has 1206 (19.8%) missing values	Missing
`offering_price` has 100 (1.6%) missing values	Missing
`offering_yield` has 1058 (17.4%) missing values	Missing
`subsequent_data` has 2506 (41.2%) missing values	Missing
`action_price` has 4998 (82.1%) missing values	Missing
`action_amount` has 4746 (78.0%) missing values	Missing
`greater_of` has 5322 (87.4%) missing values	Missing
`lesser_of` has 5322 (87.4%) missing values	Missing
`see_note` has 5322 (87.4%) missing values	Missing
`pay_in_kind` has 2502 (41.1%) missing values	Missing
`offering_yield` is highly skewed (γ1 = 70.91490893)	Skewed
`principal_amt` is highly skewed (γ1 = 61.2777128)	Skewed
`action_amount` is highly skewed (γ1 = 36.31222246)	Skewed
`isin` is uniformly distributed	Uniform
`complete_cusip` is uniformly distributed	Uniform
`issue_id` has unique values	Unique
`complete_cusip` has unique values	Unique
`offering_price` has 204 (3.4%) zeros	Zeros
`amount_outstanding` has 2079 (34.2%) zeros	Zeros

Reproduction

Analysis started	2023-08-14 16:50:52.823346
Analysis finished	2023-08-14 16:51:24.735891
Duration	31.91 seconds
Software version	ydata-profiling vv4.1.2
Download configuration	config.json

issue_id
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	6087
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	766994.93

Minimum	570533
Maximum	1042547
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	95.1 KiB

Quantile statistics

Minimum	570533
5-th percentile	583824
Q1	634829
median	744749
Q3	895369
95-th percentile	1010416.8
Maximum	1042547
Range	472014
Interquartile range (IQR)	260540

Descriptive statistics

Standard deviation	144304.64
Coefficient of variation (CV)	0.18814289
Kurtosis	-1.2858222
Mean	766994.93
Median Absolute Deviation (MAD)	124640
Skewness	0.32786087
Sum	4.6686981 × 10⁹
Variance	2.082383 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
570539	1	< 0.1%
849247	1	< 0.1%
849765	1	< 0.1%
849579	1	< 0.1%
849577	1	< 0.1%
849575	1	< 0.1%
849551	1	< 0.1%
849545	1	< 0.1%
849531	1	< 0.1%
849259	1	< 0.1%
Other values (6077)	6077	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
570533	1	< 0.1%
570535	1	< 0.1%
570539	1	< 0.1%
570547	1	< 0.1%
570549	1	< 0.1%
570551	1	< 0.1%
570553	1	< 0.1%
570577	1	< 0.1%
570581	1	< 0.1%
570587	1	< 0.1%

Value	Count	Frequency (%)
1042547	1	< 0.1%
1042546	1	< 0.1%
1042545	1	< 0.1%
1041125	1	< 0.1%
1040943	1	< 0.1%
1040942	1	< 0.1%
1040939	1	< 0.1%
1040864	1	< 0.1%
1040832	1	< 0.1%
1040686	1	< 0.1%

issuer_id
Real number (ℝ)

Distinct	1038
Distinct (%)	17.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	26958.803

Minimum	13
Maximum	51608
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	95.1 KiB

Quantile statistics

Minimum	13
5-th percentile	534
Q1	3879
median	35354
Q3	42177
95-th percentile	48129
Maximum	51608
Range	51595
Interquartile range (IQR)	38298

Descriptive statistics

Standard deviation	18425.671
Coefficient of variation (CV)	0.68347511
Kurtosis	-1.5643658
Mean	26958.803
Median Absolute Deviation (MAD)	10275
Skewness	-0.43132715
Sum	1.6409823 × 10⁸
Variance	3.3950534 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
39095	104	1.7%
32904	98	1.6%
1664	72	1.2%
4525	64	1.1%
263	61	1.0%
47149	56	0.9%
42313	49	0.8%
46381	48	0.8%
3271	48	0.8%
1255	46	0.8%
Other values (1028)	5441	89.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
13	2	< 0.1%
41	10	0.2%
74	7	0.1%
86	3	< 0.1%
104	2	< 0.1%
121	6	0.1%
169	22	0.4%
187	15	0.2%
231	9	0.1%
241	12	0.2%

Value	Count	Frequency (%)
51608	4	0.1%
51560	2	< 0.1%
51541	3	< 0.1%
51540	1	< 0.1%
51533	2	< 0.1%
51525	2	< 0.1%
51400	2	< 0.1%
51384	1	< 0.1%
51380	1	< 0.1%
51289	6	0.1%

prospectus_issuer_name
Categorical

Distinct	1069
Distinct (%)	17.6%
Missing	0
Missing (%)	0.0%
Memory size	95.1 KiB

AT&T INC	104
CITIGROUP INC	98
WESTPAC BKG CORP	64
APPLE INC	61
JPMORGAN CHASE & CO	56
Other values (1064)	5704

Length

Max length	58
Median length	49
Mean length	17.9655
Min length	5

Characters and Unicode

Total characters	109356
Distinct characters	39
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	293 ?
Unique (%)	4.8%

Sample

1st row	AT&T INC
2nd row	SYNOVUS FINL CORP
3rd row	BMC SOFTWARE INC
4th row	AT&T INC
5th row	AFLAC INC

Common Values

Value	Count	Frequency (%)
AT&T INC	104	1.7%
CITIGROUP INC	98	1.6%
WESTPAC BKG CORP	64	1.1%
APPLE INC	61	1.0%
JPMORGAN CHASE & CO	56	0.9%
GENERAL MTRS FINL CO INC	49	0.8%
SUMITOMO MITSUI FINL GROUP INC	48	0.8%
PEPSICO INC	48	0.8%
BANK NOVA SCOTIA B C	46	0.8%
DISNEY WALT CO	46	0.8%
Other values (1059)	5467	89.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
inc	2610	12.9%
corp	1444	7.1%
co	896	4.4%
group	396	2.0%
	395	2.0%
finl	339	1.7%
new	274	1.4%
plc	258	1.3%
cap	247	1.2%
fin	246	1.2%
Other values (1322)	13132	64.9%

Most occurring characters

Value	Count	Frequency (%)
	14150	12.9%
C	9477	8.7%
N	8665	7.9%
I	8093	7.4%
O	7680	7.0%
E	7470	6.8%
R	7191	6.6%
A	6494	5.9%
L	5309	4.9%
T	5142	4.7%
Other values (29)	29685	27.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	94548	86.5%
Space Separator	14150	12.9%
Other Punctuation	532	0.5%
Decimal Number	97	0.1%
Dash Punctuation	29	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	9477	10.0%
N	8665	9.2%
I	8093	8.6%
O	7680	8.1%
E	7470	7.9%
R	7191	7.6%
A	6494	6.9%
L	5309	5.6%
T	5142	5.4%
S	5102	5.4%
Other values (16)	23925	25.3%

Decimal Number

Value	Count	Frequency (%)
6	24	24.7%
3	17	17.5%
0	16	16.5%
2	15	15.5%
1	15	15.5%
4	6	6.2%
5	4	4.1%

Other Punctuation

Value	Count	Frequency (%)
&	433	81.4%
/	93	17.5%
,	5	0.9%
.	1	0.2%

Space Separator

Value	Count	Frequency (%)
	14150	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	29	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	94548	86.5%
Common	14808	13.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	9477	10.0%
N	8665	9.2%
I	8093	8.6%
O	7680	8.1%
E	7470	7.9%
R	7191	7.6%
A	6494	6.9%
L	5309	5.6%
T	5142	5.4%
S	5102	5.4%
Other values (16)	23925	25.3%

Common

Value	Count	Frequency (%)
	14150	95.6%
&	433	2.9%
/	93	0.6%
-	29	0.2%
6	24	0.2%
3	17	0.1%
0	16	0.1%
2	15	0.1%
1	15	0.1%
4	6	< 0.1%
Other values (3)	10	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	109356	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	14150	12.9%
C	9477	8.7%
N	8665	7.9%
I	8093	7.4%
O	7680	7.0%
E	7470	6.8%
R	7191	6.6%
A	6494	5.9%
L	5309	4.9%
T	5142	4.7%
Other values (29)	29685	27.1%

issuer_cusip
Categorical

Distinct	1078
Distinct (%)	17.7%
Missing	0
Missing (%)	0.0%
Memory size	95.1 KiB

00206R	104
172967	95
345397	72
961214	64
037833	61
Other values (1073)	5691

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	36522
Distinct characters	34
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	304 ?
Unique (%)	5.0%

Sample

1st row	00206R
2nd row	87161C
3rd row	055921
4th row	00206R
5th row	001055

Common Values

Value	Count	Frequency (%)
00206R	104	1.7%
172967	95	1.6%
345397	72	1.2%
961214	64	1.1%
037833	61	1.0%
46647P	56	0.9%
37045X	49	0.8%
86562M	48	0.8%
713448	48	0.8%
254687	46	0.8%
Other values (1068)	5444	89.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
00206r	104	1.7%
172967	95	1.6%
345397	72	1.2%
961214	64	1.1%
037833	61	1.0%
46647p	56	0.9%
37045x	49	0.8%
86562m	48	0.8%
713448	48	0.8%
254687	46	0.8%
Other values (1068)	5444	89.4%

Most occurring characters

Value	Count	Frequency (%)
0	4144	11.3%
6	3671	10.1%
4	3667	10.0%
2	3651	10.0%
7	3402	9.3%
3	3332	9.1%
5	3327	9.1%
1	3264	8.9%
8	2996	8.2%
9	2467	6.8%
Other values (24)	2601	7.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	33921	92.9%
Uppercase Letter	2601	7.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
P	227	8.7%
R	204	7.8%
X	191	7.3%
V	175	6.7%
H	166	6.4%
Y	160	6.2%
L	158	6.1%
M	136	5.2%
N	122	4.7%
Q	118	4.5%
Other values (14)	944	36.3%

Decimal Number

Value	Count	Frequency (%)
0	4144	12.2%
6	3671	10.8%
4	3667	10.8%
2	3651	10.8%
7	3402	10.0%
3	3332	9.8%
5	3327	9.8%
1	3264	9.6%
8	2996	8.8%
9	2467	7.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	33921	92.9%
Latin	2601	7.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
P	227	8.7%
R	204	7.8%
X	191	7.3%
V	175	6.7%
H	166	6.4%
Y	160	6.2%
L	158	6.1%
M	136	5.2%
N	122	4.7%
Q	118	4.5%
Other values (14)	944	36.3%

Common

Value	Count	Frequency (%)
0	4144	12.2%
6	3671	10.8%
4	3667	10.8%
2	3651	10.8%
7	3402	10.0%
3	3332	9.8%
5	3327	9.8%
1	3264	9.6%
8	2996	8.8%
9	2467	7.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	36522	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	4144	11.3%
6	3671	10.1%
4	3667	10.0%
2	3651	10.0%
7	3402	9.3%
3	3332	9.1%
5	3327	9.1%
1	3264	8.9%
8	2996	8.2%
9	2467	6.8%
Other values (24)	2601	7.1%

issue_cusip
Categorical

Distinct	1471
Distinct (%)	24.2%
Missing	0
Missing (%)	0.0%
Memory size	95.1 KiB

AD3	26
AF2	24
AC4	24
AC5	24
AA1	23
Other values (1466)	5966

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	18261
Distinct characters	34
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	683 ?
Unique (%)	11.2%

Sample

1st row	BB7
2nd row	AJ4
3rd row	AB6
4th row	BC5
5th row	AH5

Common Values

Value	Count	Frequency (%)
AD3	26	0.4%
AF2	24	0.4%
AC4	24	0.4%
AC5	24	0.4%
AA1	23	0.4%
AJ4	23	0.4%
AA0	23	0.4%
AA7	23	0.4%
AF9	23	0.4%
AP4	22	0.4%
Other values (1461)	5852	96.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ad3	26	0.4%
ac4	24	0.4%
ac5	24	0.4%
af2	24	0.4%
aa1	23	0.4%
aj4	23	0.4%
aa0	23	0.4%
aa7	23	0.4%
af9	23	0.4%
aa3	22	0.4%
Other values (1461)	5852	96.1%

Most occurring characters

Value	Count	Frequency (%)
A	3667	20.1%
B	1565	8.6%
C	848	4.6%
2	631	3.5%
3	626	3.4%
4	623	3.4%
9	622	3.4%
1	621	3.4%
5	618	3.4%
7	614	3.4%
Other values (24)	7826	42.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	12137	66.5%
Decimal Number	6124	33.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	3667	30.2%
B	1565	12.9%
C	848	7.0%
D	594	4.9%
E	459	3.8%
F	390	3.2%
G	379	3.1%
J	378	3.1%
H	374	3.1%
L	309	2.5%
Other values (14)	3174	26.2%

Decimal Number

Value	Count	Frequency (%)
2	631	10.3%
3	626	10.2%
4	623	10.2%
9	622	10.2%
1	621	10.1%
5	618	10.1%
7	614	10.0%
8	597	9.7%
0	595	9.7%
6	577	9.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	12137	66.5%
Common	6124	33.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	3667	30.2%
B	1565	12.9%
C	848	7.0%
D	594	4.9%
E	459	3.8%
F	390	3.2%
G	379	3.1%
J	378	3.1%
H	374	3.1%
L	309	2.5%
Other values (14)	3174	26.2%

Common

Value	Count	Frequency (%)
2	631	10.3%
3	626	10.2%
4	623	10.2%
9	622	10.2%
1	621	10.1%
5	618	10.1%
7	614	10.0%
8	597	9.7%
0	595	9.7%
6	577	9.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18261	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	3667	20.1%
B	1565	8.6%
C	848	4.6%
2	631	3.5%
3	626	3.4%
4	623	3.4%
9	622	3.4%
1	621	3.4%
5	618	3.4%
7	614	3.4%
Other values (24)	7826	42.9%

issue_name
Categorical

HIGH CARDINALITY IMBALANCE

Distinct	227
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Memory size	95.1 KiB

GLOBAL SR NT	2414
GLOBAL NT	1283
GLOBAL GTD SR NT	834
GLOBAL GTD NT	359
GLOBAL SR NT FLTG RT	208
Other values (222)	989

Length

Max length	47
Median length	44
Mean length	13.650731
Min length	2

Characters and Unicode

Total characters	83092
Distinct characters	39
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	149 ?
Unique (%)	2.4%

Sample

1st row	GLOBAL NT
2nd row	GLOBAL SR NT
3rd row	GLOBAL SR NT
4th row	GLOBAL NT
5th row	GLOBAL SR NT

Common Values

Value	Count	Frequency (%)
GLOBAL SR NT	2414	39.7%
GLOBAL NT	1283	21.1%
GLOBAL GTD SR NT	834	13.7%
GLOBAL GTD NT	359	5.9%
GLOBAL SR NT FLTG RT	208	3.4%
GLOBAL NT FLTG RT	172	2.8%
GLOBAL SR NT FIXED/FLTG RT	108	1.8%
GLOBAL NT FIXED/FLTG RT	53	0.9%
GLOBAL 1ST MTG BD	50	0.8%
GLOBAL SUB NT FIXED/FLTG RT	47	0.8%
Other values (217)	559	9.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
global	6051	30.5%
nt	5910	29.8%
sr	3837	19.4%
gtd	1381	7.0%
rt	759	3.8%
fltg	533	2.7%
fixed/fltg	222	1.1%
ser	167	0.8%
bd	129	0.7%
sub	122	0.6%
Other values (135)	712	3.6%

Most occurring characters

Value	Count	Frequency (%)
	13736	16.5%
L	12911	15.5%
T	9080	10.9%
G	8318	10.0%
B	6392	7.7%
A	6150	7.4%
O	6092	7.3%
N	5973	7.2%
R	4843	5.8%
S	4303	5.2%
Other values (29)	5294	6.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	68677	82.7%
Space Separator	13736	16.5%
Decimal Number	387	0.5%
Other Punctuation	284	0.3%
Dash Punctuation	8	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
L	12911	18.8%
T	9080	13.2%
G	8318	12.1%
B	6392	9.3%
A	6150	9.0%
O	6092	8.9%
N	5973	8.7%
R	4843	7.1%
S	4303	6.3%
D	1899	2.8%
Other values (16)	2716	4.0%

Decimal Number

Value	Count	Frequency (%)
1	158	40.8%
2	114	29.5%
0	74	19.1%
8	14	3.6%
7	9	2.3%
9	6	1.6%
5	5	1.3%
3	4	1.0%
6	3	0.8%

Other Punctuation

Value	Count	Frequency (%)
/	258	90.8%
&	26	9.2%

Space Separator

Value	Count	Frequency (%)
	13736	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	8	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	68677	82.7%
Common	14415	17.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
L	12911	18.8%
T	9080	13.2%
G	8318	12.1%
B	6392	9.3%
A	6150	9.0%
O	6092	8.9%
N	5973	8.7%
R	4843	7.1%
S	4303	6.3%
D	1899	2.8%
Other values (16)	2716	4.0%

Common

Value	Count	Frequency (%)
	13736	95.3%
/	258	1.8%
1	158	1.1%
2	114	0.8%
0	74	0.5%
&	26	0.2%
8	14	0.1%
7	9	0.1%
-	8	0.1%
9	6	< 0.1%
Other values (3)	12	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	83092	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	13736	16.5%
L	12911	15.5%
T	9080	10.9%
G	8318	10.0%
B	6392	7.7%
A	6150	7.4%
O	6092	7.3%
N	5973	7.2%
R	4843	5.8%
S	4303	5.2%
Other values (29)	5294	6.4%

maturity
Date

Distinct	2340
Distinct (%)	38.4%
Missing	0
Missing (%)	0.0%
Memory size	95.1 KiB

Minimum	2013-09-13 00:00:00
Maximum	2052-05-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

security_level
Categorical

Distinct	6
Distinct (%)	0.1%
Missing	6
Missing (%)	0.1%
Memory size	95.1 KiB

SEN	5839
SS	122
SUB	104
SENS	9
JUNS	6

Length

Max length	4
Median length	3
Mean length	2.9824042
Min length	2

Characters and Unicode

Total characters	18136
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	SEN
2nd row	SEN
3rd row	SEN
4th row	SEN
5th row	SEN

Common Values

Value	Count	Frequency (%)
SEN	5839	95.9%
SS	122	2.0%
SUB	104	1.7%
SENS	9	0.1%
JUNS	6	0.1%
NON	1	< 0.1%
(Missing)	6	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
sen	5839	96.0%
ss	122	2.0%
sub	104	1.7%
sens	9	0.1%
juns	6	0.1%
non	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
S	6211	34.2%
N	5856	32.3%
E	5848	32.2%
U	110	0.6%
B	104	0.6%
J	6	< 0.1%
O	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	18136	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	6211	34.2%
N	5856	32.3%
E	5848	32.2%
U	110	0.6%
B	104	0.6%
J	6	< 0.1%
O	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	18136	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	6211	34.2%
N	5856	32.3%
E	5848	32.2%
U	110	0.6%
B	104	0.6%
J	6	< 0.1%
O	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18136	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	6211	34.2%
N	5856	32.3%
E	5848	32.2%
U	110	0.6%
B	104	0.6%
J	6	< 0.1%
O	1	< 0.1%

enhancement
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.5 KiB

False	4696
True	1391

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	4696	77.1%
True	1391	22.9%

coupon_type
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	95.1 KiB

F	5314
V	772

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	6086
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	F
2nd row	F
3rd row	F
4th row	F
5th row	F

Common Values

Value	Count	Frequency (%)
F	5314	87.3%
V	772	12.7%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
f	5314	87.3%
v	772	12.7%

Most occurring characters

Value	Count	Frequency (%)
F	5314	87.3%
V	772	12.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	6086	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
F	5314	87.3%
V	772	12.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6086	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
F	5314	87.3%
V	772	12.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6086	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
F	5314	87.3%
V	772	12.7%

mtn
Boolean

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.5 KiB

False	6085
True	2

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	6085	> 99.9%
True	2	< 0.1%

asset_backed
Boolean

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.5 KiB

False	6087

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	6087	100.0%

yankee
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.5 KiB

False	5139
True	948

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	5139	84.4%
True	948	15.6%

canadian
Boolean

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.5 KiB

False	5967
True	120

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	5967	98.0%
True	120	2.0%

oid
Boolean

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.5 KiB

False	6087

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	6087	100.0%

slob
Boolean

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.5 KiB

False	6087

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	6087	100.0%

issue_offered_global
Boolean

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.5 KiB

True	6087

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	6087	100.0%

settlement_type
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	95.1 KiB

S	6081
N	6

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	6087
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	S
2nd row	S
3rd row	S
4th row	S
5th row	S

Common Values

Value	Count	Frequency (%)
S	6081	99.9%
N	6	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
s	6081	99.9%
n	6	0.1%

Most occurring characters

Value	Count	Frequency (%)
S	6081	99.9%
N	6	0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	6087	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	6081	99.9%
N	6	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6087	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	6081	99.9%
N	6	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6087	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	6081	99.9%
N	6	0.1%

gross_spread
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	137
Distinct (%)	2.4%
Missing	348
Missing (%)	5.7%
Infinite	0
Infinite (%)	0.0%
Mean	5.020101

Minimum	0.35
Maximum	30
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	95.1 KiB

Quantile statistics

Minimum	0.35
5-th percentile	1.5
Q1	3.5
median	4.5
Q3	6.5
95-th percentile	8.75
Maximum	30
Range	29.65
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.619326
Coefficient of variation (CV)	0.52176759
Kurtosis	7.1586594
Mean	5.020101
Median Absolute Deviation (MAD)	2
Skewness	1.7130547
Sum	28810.36
Variance	6.8608687
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.5	1359	22.3%
4.5	688	11.3%
3.5	647	10.6%
6	498	8.2%
2.5	463	7.6%
4	285	4.7%
3	174	2.9%
2	173	2.8%
6.25	169	2.8%
1.5	149	2.4%
Other values (127)	1134	18.6%
(Missing)	348	5.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.35	2	< 0.1%
0.4	1	< 0.1%
0.5	5	0.1%
0.6	1	< 0.1%
0.65	1	< 0.1%
0.7	1	< 0.1%
0.75	5	0.1%
0.8	11	0.2%
0.9	1	< 0.1%
1	77	1.3%

Value	Count	Frequency (%)
30	1	< 0.1%
28.333	1	< 0.1%
22.5	2	< 0.1%
20	7	0.1%
19.6	1	< 0.1%
19.53	1	< 0.1%
19	1	< 0.1%
18.4	1	< 0.1%
17.927	1	< 0.1%
17.86	1	< 0.1%

selling_concession
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	94
Distinct (%)	1.9%
Missing	1206
Missing (%)	19.8%
Infinite	0
Infinite (%)	0.0%
Mean	2.9216462

Minimum	0.08
Maximum	28.333
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	95.1 KiB

Quantile statistics

Minimum	0.08
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	4.5
Maximum	28.333
Range	28.253
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.3039729
Coefficient of variation (CV)	0.44631446
Kurtosis	33.519418
Mean	2.9216462
Median Absolute Deviation (MAD)	1
Skewness	2.0589071
Sum	14260.555
Variance	1.7003454
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	1247	20.5%
2	613	10.1%
2.5	516	8.5%
3.5	444	7.3%
1.5	416	6.8%
3	244	4.0%
3.75	190	3.1%
1	177	2.9%
5	118	1.9%
4.5	81	1.3%
Other values (84)	835	13.7%
(Missing)	1206	19.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.08	1	< 0.1%
0.2	2	< 0.1%
0.25	1	< 0.1%
0.3	4	0.1%
0.35	1	< 0.1%
0.4	3	< 0.1%
0.45	5	0.1%
0.48	5	0.1%
0.5	16	0.3%
0.6	57	0.9%

Value	Count	Frequency (%)
28.333	1	< 0.1%
18	1	< 0.1%
12.533	1	< 0.1%
10	3	< 0.1%
9	2	< 0.1%
8.75	1	< 0.1%
8.25	1	< 0.1%
7.5	6	0.1%
7	5	0.1%
6.75	4	0.1%

comp_neg_exch_deal
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	95.1 KiB

NEG	5787
EXCH	300

Length

Max length	4
Median length	3
Mean length	3.0492854
Min length	3

Characters and Unicode

Total characters	18561
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NEG
2nd row	NEG
3rd row	NEG
4th row	NEG
5th row	NEG

Common Values

Value	Count	Frequency (%)
NEG	5787	95.1%
EXCH	300	4.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
neg	5787	95.1%
exch	300	4.9%

Most occurring characters

Value	Count	Frequency (%)
E	6087	32.8%
N	5787	31.2%
G	5787	31.2%
X	300	1.6%
C	300	1.6%
H	300	1.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	18561	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	6087	32.8%
N	5787	31.2%
G	5787	31.2%
X	300	1.6%
C	300	1.6%
H	300	1.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	18561	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	6087	32.8%
N	5787	31.2%
G	5787	31.2%
X	300	1.6%
C	300	1.6%
H	300	1.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18561	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	6087	32.8%
N	5787	31.2%
G	5787	31.2%
X	300	1.6%
C	300	1.6%
H	300	1.6%

rule_415_reg
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.5 KiB

True	3675
False	2412

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	3675	60.4%
False	2412	39.6%

sec_reg_type1
Categorical

HIGH CORRELATION IMBALANCE

Distinct	12
Distinct (%)	0.2%
Missing	32
Missing (%)	0.5%
Memory size	95.1 KiB

S-3	2637
RBNA	2611
F-3	483
S-4	230
F-4	38
Other values (7)	56

Length

Max length	4
Median length	3
Mean length	3.4351775
Min length	2

Characters and Unicode

Total characters	20800
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	RBNA
2nd row	RBNA
3rd row	S-3
4th row	RBNA
5th row	RBNA

Common Values

Value	Count	Frequency (%)
S-3	2637	43.3%
RBNA	2611	42.9%
F-3	483	7.9%
S-4	230	3.8%
F-4	38	0.6%
F-10	28	0.5%
F-6	9	0.1%
F-9	7	0.1%
S-1	5	0.1%
NR	4	0.1%
Other values (2)	3	< 0.1%
(Missing)	32	0.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
s-3	2637	43.6%
rbna	2611	43.1%
f-3	483	8.0%
s-4	230	3.8%
f-4	38	0.6%
f-10	28	0.5%
f-6	9	0.1%
f-9	7	0.1%
s-1	5	0.1%
nr	4	0.1%
Other values (2)	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
-	3440	16.5%
3	3120	15.0%
S	2875	13.8%
R	2615	12.6%
N	2615	12.6%
B	2611	12.6%
A	2611	12.6%
F	565	2.7%
4	268	1.3%
1	33	0.2%
Other values (5)	47	0.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	13892	66.8%
Decimal Number	3468	16.7%
Dash Punctuation	3440	16.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
3	3120	90.0%
4	268	7.7%
1	33	1.0%
0	28	0.8%
6	9	0.3%
9	7	0.2%
2	2	0.1%
8	1	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
S	2875	20.7%
R	2615	18.8%
N	2615	18.8%
B	2611	18.8%
A	2611	18.8%
F	565	4.1%

Dash Punctuation

Value	Count	Frequency (%)
-	3440	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	13892	66.8%
Common	6908	33.2%

Most frequent character per script

Common

Value	Count	Frequency (%)
-	3440	49.8%
3	3120	45.2%
4	268	3.9%
1	33	0.5%
0	28	0.4%
6	9	0.1%
9	7	0.1%
2	2	< 0.1%
8	1	< 0.1%

Latin

Value	Count	Frequency (%)
S	2875	20.7%
R	2615	18.8%
N	2615	18.8%
B	2611	18.8%
A	2611	18.8%
F	565	4.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20800	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	3440	16.5%
3	3120	15.0%
S	2875	13.8%
R	2615	12.6%
N	2615	12.6%
B	2611	12.6%
A	2611	12.6%
F	565	2.7%
4	268	1.3%
1	33	0.2%
Other values (5)	47	0.2%

offering_amt
Real number (ℝ)

Distinct	375
Distinct (%)	6.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	878446.4

Minimum	379
Maximum	11000000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	95.1 KiB

Quantile statistics

Minimum	379
5-th percentile	300000
Q1	500000
median	700000
Q3	1000000
95-th percentile	2000000
Maximum	11000000
Range	10999621
Interquartile range (IQR)	500000

Descriptive statistics

Standard deviation	693083.78
Coefficient of variation (CV)	0.78898812
Kurtosis	29.806007
Mean	878446.4
Median Absolute Deviation (MAD)	300000
Skewness	3.733875
Sum	5.3471032 × 10⁹
Variance	4.8036512 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
500000	959	15.8%
1000000	720	11.8%
750000	571	9.4%
400000	364	6.0%
1250000	328	5.4%
300000	316	5.2%
600000	305	5.0%
1500000	294	4.8%
350000	197	3.2%
250000	167	2.7%
Other values (365)	1866	30.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
379	1	< 0.1%
727	1	< 0.1%
8040	1	< 0.1%
11000	1	< 0.1%
13811	1	< 0.1%
21000	1	< 0.1%
21270	1	< 0.1%
27250	1	< 0.1%
29802	1	< 0.1%
30000	1	< 0.1%

Value	Count	Frequency (%)
11000000	2	< 0.1%
9518964	1	< 0.1%
9000000	1	< 0.1%
7500000	1	< 0.1%
6000000	4	0.1%
5500000	2	< 0.1%
5400614	1	< 0.1%
5341555	1	< 0.1%
5000000	7	0.1%
4750000	1	< 0.1%

offering_date
Date

Distinct	1513
Distinct (%)	24.9%
Missing	0
Missing (%)	0.0%
Memory size	95.1 KiB

Minimum	2012-02-08 00:00:00
Maximum	2022-06-28 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

offering_price
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	1049
Distinct (%)	17.5%
Missing	100
Missing (%)	1.6%
Infinite	0
Infinite (%)	0.0%
Mean	96.36492

Minimum	0
Maximum	110.146
Zeros	204
Zeros (%)	3.4%
Negative	0
Negative (%)	0.0%
Memory size	95.1 KiB

Quantile statistics

Minimum	0
5-th percentile	98.684
Q1	99.644
median	99.861
Q3	99.992
95-th percentile	100
Maximum	110.146
Range	110.146
Interquartile range (IQR)	0.348

Descriptive statistics

Standard deviation	18.105223
Coefficient of variation (CV)	0.18788189
Kurtosis	24.377046
Mean	96.36492
Median Absolute Deviation (MAD)	0.139
Skewness	-5.1335679
Sum	576936.78
Variance	327.79911
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	1398	23.0%
0	204	3.4%
99.994	25	0.4%
99.991	24	0.4%
99.929	21	0.3%
99.99	20	0.3%
99.982	20	0.3%
99.83	19	0.3%
99.981	19	0.3%
99.912	18	0.3%
Other values (1039)	4219	69.3%
(Missing)	100	1.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	204	3.4%
90	1	< 0.1%
95.273	1	< 0.1%
95.291	1	< 0.1%
95.304	1	< 0.1%
95.444	1	< 0.1%
95.83	1	< 0.1%
97.052	1	< 0.1%
97.084	1	< 0.1%
97.09	1	< 0.1%

Value	Count	Frequency (%)
110.146	1	< 0.1%
106.94884	1	< 0.1%
104.688	1	< 0.1%
102.776	1	< 0.1%
102.002	1	< 0.1%
101.414	1	< 0.1%
101.1867	1	< 0.1%
100.763	1	< 0.1%
100.63342	1	< 0.1%
100.5119	1	< 0.1%

offering_yield
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED

Distinct	4485
Distinct (%)	89.2%
Missing	1058
Missing (%)	17.4%
Infinite	0
Infinite (%)	0.0%
Mean	351.93157

Minimum	0.25702
Maximum	1750000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	95.1 KiB

Quantile statistics

Minimum	0.25702
5-th percentile	1.182478
Q1	2.302
median	3.13045
Q3	3.91189
95-th percentile	5.25
Maximum	1750000
Range	1749999.7
Interquartile range (IQR)	1.60989

Descriptive statistics

Standard deviation	24677.283
Coefficient of variation (CV)	70.11955
Kurtosis	5028.9495
Mean	351.93157
Median Absolute Deviation (MAD)	0.80455
Skewness	70.914909
Sum	1769863.8
Variance	6.0896829 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.375	17	0.3%
5	15	0.2%
5.25	14	0.2%
5.125	13	0.2%
5.875	13	0.2%
4.75	13	0.2%
5.75	12	0.2%
5.5	10	0.2%
5.625	10	0.2%
4.25	9	0.1%
Other values (4475)	4903	80.5%
(Missing)	1058	17.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.25702	1	< 0.1%
0.309	1	< 0.1%
0.333	1	< 0.1%
0.34482	1	< 0.1%
0.36387	1	< 0.1%
0.37418	1	< 0.1%
0.3878	1	< 0.1%
0.40085	1	< 0.1%
0.418	1	< 0.1%
0.41914	1	< 0.1%

Value	Count	Frequency (%)
1750000	1	< 0.1%
3924	1	< 0.1%
15	1	< 0.1%
12.5	1	< 0.1%
12.0962	1	< 0.1%
10.37761	1	< 0.1%
10.125	1	< 0.1%
9.99964	1	< 0.1%
9.99465	1	< 0.1%
9.75	1	< 0.1%

delivery_date
Categorical

Distinct	1744
Distinct (%)	28.7%
Missing	0
Missing (%)	0.0%
Memory size	95.1 KiB

2019-11-25	35
2019-06-03	24
2019-09-16	21
2018-11-26	19
2020-03-25	18
Other values (1739)	5970

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	60870
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	465 ?
Unique (%)	7.6%

Sample

1st row	2012-02-13
2nd row	2012-02-13
3rd row	2012-02-13
4th row	2012-02-13
5th row	2012-02-10

Common Values

Value	Count	Frequency (%)
2019-11-25	35	0.6%
2019-06-03	24	0.4%
2019-09-16	21	0.3%
2018-11-26	19	0.3%
2020-03-25	18	0.3%
2017-05-11	18	0.3%
2020-05-18	16	0.3%
2018-12-13	16	0.3%
2020-03-27	15	0.2%
2015-03-12	15	0.2%
Other values (1734)	5890	96.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2019-11-25	35	0.6%
2019-06-03	24	0.4%
2019-09-16	21	0.3%
2018-11-26	19	0.3%
2020-03-25	18	0.3%
2017-05-11	18	0.3%
2020-05-18	16	0.3%
2018-12-13	16	0.3%
2020-03-27	15	0.2%
2015-03-12	15	0.2%
Other values (1734)	5890	96.8%

Most occurring characters

Value	Count	Frequency (%)
0	14417	23.7%
-	12174	20.0%
2	11793	19.4%
1	10340	17.0%
3	2197	3.6%
5	1833	3.0%
9	1793	2.9%
8	1757	2.9%
6	1655	2.7%
7	1472	2.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	48696	80.0%
Dash Punctuation	12174	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	14417	29.6%
2	11793	24.2%
1	10340	21.2%
3	2197	4.5%
5	1833	3.8%
9	1793	3.7%
8	1757	3.6%
6	1655	3.4%
7	1472	3.0%
4	1439	3.0%

Dash Punctuation

Value	Count	Frequency (%)
-	12174	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	60870	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	14417	23.7%
-	12174	20.0%
2	11793	19.4%
1	10340	17.0%
3	2197	3.6%
5	1833	3.0%
9	1793	2.9%
8	1757	2.9%
6	1655	2.7%
7	1472	2.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	60870	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	14417	23.7%
-	12174	20.0%
2	11793	19.4%
1	10340	17.0%
3	2197	3.6%
5	1833	3.0%
9	1793	2.9%
8	1757	2.9%
6	1655	2.7%
7	1472	2.4%

unit_deal
Boolean

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.5 KiB

False	6087

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	6087	100.0%

form_of_own
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	95.1 KiB

BE	6087

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	12174
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BE
2nd row	BE
3rd row	BE
4th row	BE
5th row	BE

Common Values

Value	Count	Frequency (%)
BE	6087	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
be	6087	100.0%

Most occurring characters

Value	Count	Frequency (%)
B	6087	50.0%
E	6087	50.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	12174	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
B	6087	50.0%
E	6087	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	12174	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
B	6087	50.0%
E	6087	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12174	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
B	6087	50.0%
E	6087	50.0%

denomination
Categorical

HIGH CORRELATION IMBALANCE

Distinct	13
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	95.1 KiB

2/1	4883
1/1	608
200/1	433
100/1	95
150/1	36
Other values (8)	32

Length

Max length	8
Median length	3
Mean length	3.1920486
Min length	3

Characters and Unicode

Total characters	19430
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	0.1%

Sample

1st row	2/1
2nd row	2/1
3rd row	2/1
4th row	2/1
5th row	2/1

Common Values

Value	Count	Frequency (%)
2/1	4883	80.2%
1/1	608	10.0%
200/1	433	7.1%
100/1	95	1.6%
150/1	36	0.6%
5/1	12	0.2%
250/1	11	0.2%
200/2	3	< 0.1%
75/1	2	< 0.1%
10/1	1	< 0.1%
Other values (3)	3	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2/1	4883	80.2%
1/1	608	10.0%
200/1	433	7.1%
100/1	95	1.6%
150/1	36	0.6%
5/1	12	0.2%
250/1	11	0.2%
200/2	3	< 0.1%
75/1	2	< 0.1%
10/1	1	< 0.1%
Other values (3)	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
1	6824	35.1%
/	6087	31.3%
2	5334	27.5%
0	1119	5.8%
5	64	0.3%
7	2	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	13343	68.7%
Other Punctuation	6087	31.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	6824	51.1%
2	5334	40.0%
0	1119	8.4%
5	64	0.5%
7	2	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
/	6087	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	19430	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	6824	35.1%
/	6087	31.3%
2	5334	27.5%
0	1119	5.8%
5	64	0.3%
7	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	19430	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	6824	35.1%
/	6087	31.3%
2	5334	27.5%
0	1119	5.8%
5	64	0.3%
7	2	< 0.1%

principal_amt
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1967.1433

Minimum	0
Maximum	2000000
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	95.1 KiB

Quantile statistics

Minimum	0
5-th percentile	1000
Q1	1000
median	1000
Q3	1000
95-th percentile	1000
Maximum	2000000
Range	2000000
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	27929.902
Coefficient of variation (CV)	14.198204
Kurtosis	4312.2779
Mean	1967.1433
Median Absolute Deviation (MAD)	0
Skewness	61.277713
Sum	11974001
Variance	7.8007943 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
1000	6060	99.6%
200000	18	0.3%
150000	2	< 0.1%
2000	2	< 0.1%
5000	2	< 0.1%
1	1	< 0.1%
0	1	< 0.1%
2000000	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
1000	6060	99.6%
2000	2	< 0.1%
5000	2	< 0.1%
150000	2	< 0.1%
200000	18	0.3%
2000000	1	< 0.1%

Value	Count	Frequency (%)
2000000	1	< 0.1%
200000	18	0.3%
150000	2	< 0.1%
5000	2	< 0.1%
2000	2	< 0.1%
1000	6060	99.6%
1	1	< 0.1%
0	1	< 0.1%

covenants
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	59.4 KiB

True	5915
False	171
(Missing)	1

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	5915	97.2%
False	171	2.8%
(Missing)	1	< 0.1%

defeased
Boolean

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.5 KiB

False	6086
True	1

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	6086	> 99.9%
True	1	< 0.1%

defaulted
Boolean

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.5 KiB

False	6086
True	1

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	6086	> 99.9%
True	1	< 0.1%

tender_exch_offer
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.5 KiB

False	5251
True	836

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	5251	86.3%
True	836	13.7%

redeemable
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.5 KiB

True	5462
False	625

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	5462	89.7%
False	625	10.3%

refund_protection
Boolean

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.5 KiB

False	6086
True	1

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	6086	> 99.9%
True	1	< 0.1%

overallotment_opt
Boolean

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.5 KiB

False	6084
True	3

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	6084	> 99.9%
True	3	< 0.1%

announced_call
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.5 KiB

False	6059
True	28

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	6059	99.5%
True	28	0.5%

active_issue
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.5 KiB

True	4008
False	2079

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	4008	65.8%
False	2079	34.2%

dep_eligibility
Categorical

Distinct	6
Distinct (%)	0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	95.1 KiB

DCE	5986
DTC	73
EUCD	21
DCED	3
DE	2

Length

Max length	4
Median length	3
Mean length	3.0037792
Min length	2

Characters and Unicode

Total characters	18281
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	DCE
2nd row	DCE
3rd row	DCE
4th row	DCE
5th row	DCE

Common Values

Value	Count	Frequency (%)
DCE	5986	98.3%
DTC	73	1.2%
EUCD	21	0.3%
DCED	3	< 0.1%
DE	2	< 0.1%
DFEC	1	< 0.1%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
dce	5986	98.4%
dtc	73	1.2%
eucd	21	0.3%
dced	3	< 0.1%
de	2	< 0.1%
dfec	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
D	6089	33.3%
C	6084	33.3%
E	6013	32.9%
T	73	0.4%
U	21	0.1%
F	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	18281	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
D	6089	33.3%
C	6084	33.3%
E	6013	32.9%
T	73	0.4%
U	21	0.1%
F	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	18281	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	6089	33.3%
C	6084	33.3%
E	6013	32.9%
T	73	0.4%
U	21	0.1%
F	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18281	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
D	6089	33.3%
C	6084	33.3%
E	6013	32.9%
T	73	0.4%
U	21	0.1%
F	1	< 0.1%

bond_type
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	95.1 KiB

CDEB	6087

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	24348
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CDEB
2nd row	CDEB
3rd row	CDEB
4th row	CDEB
5th row	CDEB

Common Values

Value	Count	Frequency (%)
CDEB	6087	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
cdeb	6087	100.0%

Most occurring characters

Value	Count	Frequency (%)
C	6087	25.0%
D	6087	25.0%
E	6087	25.0%
B	6087	25.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	24348	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	6087	25.0%
D	6087	25.0%
E	6087	25.0%
B	6087	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	24348	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	6087	25.0%
D	6087	25.0%
E	6087	25.0%
B	6087	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24348	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	6087	25.0%
D	6087	25.0%
E	6087	25.0%
B	6087	25.0%

subsequent_data
Boolean

HIGH CORRELATION MISSING

Distinct	2
Distinct (%)	0.1%
Missing	2506
Missing (%)	41.2%
Memory size	59.4 KiB

True	3181
False	400
(Missing)	2506

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	3181	52.3%
False	400	6.6%
(Missing)	2506	41.2%

isin
Categorical

HIGH CARDINALITY UNIFORM

Distinct	6080
Distinct (%)	100.0%
Missing	7
Missing (%)	0.1%
Memory size	95.1 KiB

US00206RBB78	1
US30034WAA45	1
US44106MAZ59	1
US714046AG46	1
US60687YBA64	1
Other values (6075)	6075

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	72960
Distinct characters	34
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6080 ?
Unique (%)	100.0%

Sample

1st row	US00206RBB78
2nd row	US87161CAJ45
3rd row	US055921AB64
4th row	US00206RBC51
5th row	US001055AH52

Common Values

Value	Count	Frequency (%)
US00206RBB78	1	< 0.1%
US30034WAA45	1	< 0.1%
US44106MAZ59	1	< 0.1%
US714046AG46	1	< 0.1%
US60687YBA64	1	< 0.1%
US60687YAZ25	1	< 0.1%
US60687YBB48	1	< 0.1%
US34964CAE66	1	< 0.1%
US88947EAU47	1	< 0.1%
US72346QAC87	1	< 0.1%
Other values (6070)	6070	99.7%
(Missing)	7	0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
us00206rbb78	1	< 0.1%
us02005nal47	1	< 0.1%
us00206rbc51	1	< 0.1%
us001055ah52	1	< 0.1%
us001055aj19	1	< 0.1%
us00206rbd35	1	< 0.1%
us489170ac47	1	< 0.1%
us35671dav73	1	< 0.1%
us35671daw56	1	< 0.1%
us35671dau90	1	< 0.1%
Other values (6070)	6070	99.8%

Most occurring characters

Value	Count	Frequency (%)
U	6360	8.7%
S	6326	8.7%
0	5349	7.3%
4	4905	6.7%
2	4879	6.7%
6	4825	6.6%
7	4619	6.3%
3	4568	6.3%
5	4538	6.2%
1	4507	6.2%
Other values (24)	22084	30.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	46088	63.2%
Uppercase Letter	26872	36.8%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
U	6360	23.7%
S	6326	23.5%
A	3740	13.9%
B	1647	6.1%
C	955	3.6%
D	671	2.5%
E	543	2.0%
H	540	2.0%
P	484	1.8%
L	465	1.7%
Other values (14)	5141	19.1%

Decimal Number

Value	Count	Frequency (%)
0	5349	11.6%
4	4905	10.6%
2	4879	10.6%
6	4825	10.5%
7	4619	10.0%
3	4568	9.9%
5	4538	9.8%
1	4507	9.8%
8	4169	9.0%
9	3729	8.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	46088	63.2%
Latin	26872	36.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
U	6360	23.7%
S	6326	23.5%
A	3740	13.9%
B	1647	6.1%
C	955	3.6%
D	671	2.5%
E	543	2.0%
H	540	2.0%
P	484	1.8%
L	465	1.7%
Other values (14)	5141	19.1%

Common

Value	Count	Frequency (%)
0	5349	11.6%
4	4905	10.6%
2	4879	10.6%
6	4825	10.5%
7	4619	10.0%
3	4568	9.9%
5	4538	9.8%
1	4507	9.8%
8	4169	9.0%
9	3729	8.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	72960	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
U	6360	8.7%
S	6326	8.7%
0	5349	7.3%
4	4905	6.7%
2	4879	6.7%
6	4825	6.6%
7	4619	6.3%
3	4568	6.3%
5	4538	6.2%
1	4507	6.2%
Other values (24)	22084	30.3%

fungible
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	53.5 KiB

True	4229
False	1858

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	4229	69.5%
False	1858	30.5%

complete_cusip
Categorical

HIGH CARDINALITY UNIFORM UNIQUE

Distinct	6087
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	95.1 KiB

00206RBB7	1
46647PBE5	1
714046AG4	1
60687YBA6	1
60687YAZ2	1
Other values (6082)	6082

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	54783
Distinct characters	35
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6087 ?
Unique (%)	100.0%

Sample

1st row	00206RBB7
2nd row	87161CAJ4
3rd row	055921AB6
4th row	00206RBC5
5th row	001055AH5

Common Values

Value	Count	Frequency (%)
00206RBB7	1	< 0.1%
46647PBE5	1	< 0.1%
714046AG4	1	< 0.1%
60687YBA6	1	< 0.1%
60687YAZ2	1	< 0.1%
60687YBB4	1	< 0.1%
34964CAE6	1	< 0.1%
88947EAU4	1	< 0.1%
72346QAC8	1	< 0.1%
30034WAB2	1	< 0.1%
Other values (6077)	6077	99.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
00206rbb7	1	< 0.1%
02005nal4	1	< 0.1%
00206rbc5	1	< 0.1%
001055ah5	1	< 0.1%
001055aj1	1	< 0.1%
00206rbd3	1	< 0.1%
489170ac4	1	< 0.1%
35671dav7	1	< 0.1%
35671daw5	1	< 0.1%
35671dau9	1	< 0.1%
Other values (6077)	6077	99.8%

Most occurring characters

Value	Count	Frequency (%)
0	4739	8.7%
4	4290	7.8%
2	4282	7.8%
6	4248	7.8%
7	4016	7.3%
3	3958	7.2%
5	3945	7.2%
1	3885	7.1%
A	3744	6.8%
8	3593	6.6%
Other values (25)	14083	25.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	40045	73.1%
Uppercase Letter	14738	26.9%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	3744	25.4%
B	1652	11.2%
C	955	6.5%
D	671	4.6%
E	543	3.7%
H	540	3.7%
P	484	3.3%
L	467	3.2%
G	453	3.1%
F	451	3.1%
Other values (15)	4778	32.4%

Decimal Number

Value	Count	Frequency (%)
0	4739	11.8%
4	4290	10.7%
2	4282	10.7%
6	4248	10.6%
7	4016	10.0%
3	3958	9.9%
5	3945	9.9%
1	3885	9.7%
8	3593	9.0%
9	3089	7.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	40045	73.1%
Latin	14738	26.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	3744	25.4%
B	1652	11.2%
C	955	6.5%
D	671	4.6%
E	543	3.7%
H	540	3.7%
P	484	3.3%
L	467	3.2%
G	453	3.1%
F	451	3.1%
Other values (15)	4778	32.4%

Common

Value	Count	Frequency (%)
0	4739	11.8%
4	4290	10.7%
2	4282	10.7%
6	4248	10.6%
7	4016	10.0%
3	3958	9.9%
5	3945	9.9%
1	3885	9.7%
8	3593	9.0%
9	3089	7.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	54783	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	4739	8.7%
4	4290	7.8%
2	4282	7.8%
6	4248	7.8%
7	4016	7.3%
3	3958	7.2%
5	3945	7.2%
1	3885	7.1%
A	3744	6.8%
8	3593	6.6%
Other values (25)	14083	25.7%

action_type
Categorical

Distinct	12
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	95.1 KiB

I	3417
IM	1326
E	471
B	259
T	259
Other values (7)	355

Length

Max length	3
Median length	1
Mean length	1.2640053
Min length	1

Characters and Unicode

Total characters	7694
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	E
2nd row	E
3rd row	B
4th row	IM
5th row	IM

Common Values

Value	Count	Frequency (%)
I	3417	56.1%
IM	1326	21.8%
E	471	7.7%
B	259	4.3%
T	259	4.3%
RO	138	2.3%
X	107	1.8%
REV	60	1.0%
P	20	0.3%
R	18	0.3%
Other values (2)	12	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
i	3417	56.1%
im	1326	21.8%
e	471	7.7%
b	259	4.3%
t	259	4.3%
ro	138	2.3%
x	107	1.8%
rev	60	1.0%
p	20	0.3%
r	18	0.3%
Other values (2)	12	0.2%

Most occurring characters

Value	Count	Frequency (%)
I	4754	61.8%
M	1326	17.2%
E	531	6.9%
B	259	3.4%
T	259	3.4%
R	227	3.0%
O	139	1.8%
X	107	1.4%
V	60	0.8%
P	31	0.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	7694	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	4754	61.8%
M	1326	17.2%
E	531	6.9%
B	259	3.4%
T	259	3.4%
R	227	3.0%
O	139	1.8%
X	107	1.4%
V	60	0.8%
P	31	0.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7694	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	4754	61.8%
M	1326	17.2%
E	531	6.9%
B	259	3.4%
T	259	3.4%
R	227	3.0%
O	139	1.8%
X	107	1.4%
V	60	0.8%
P	31	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7694	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	4754	61.8%
M	1326	17.2%
E	531	6.9%
B	259	3.4%
T	259	3.4%
R	227	3.0%
O	139	1.8%
X	107	1.4%
V	60	0.8%
P	31	0.4%

effective_date
Categorical

Distinct	1767
Distinct (%)	29.0%
Missing	0
Missing (%)	0.0%
Memory size	95.1 KiB

2019-11-25	33
2022-05-20	27
2020-05-11	21
2021-11-08	21
2020-05-07	19
Other values (1762)	5966

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	60870
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	572 ?
Unique (%)	9.4%

Sample

1st row	2014-07-15
2nd row	2017-11-09
3rd row	2018-11-01
4th row	2017-02-15
5th row	2017-02-15

Common Values

Value	Count	Frequency (%)
2019-11-25	33	0.5%
2022-05-20	27	0.4%
2020-05-11	21	0.3%
2021-11-08	21	0.3%
2020-05-07	19	0.3%
2019-09-16	19	0.3%
2021-03-15	18	0.3%
2020-03-26	17	0.3%
2020-08-10	17	0.3%
2020-03-04	17	0.3%
Other values (1757)	5878	96.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2019-11-25	33	0.5%
2022-05-20	27	0.4%
2020-05-11	21	0.3%
2021-11-08	21	0.3%
2020-05-07	19	0.3%
2019-09-16	19	0.3%
2021-03-15	18	0.3%
2020-03-26	17	0.3%
2020-08-10	17	0.3%
2020-03-04	17	0.3%
Other values (1757)	5878	96.6%

Most occurring characters

Value	Count	Frequency (%)
0	15050	24.7%
2	12827	21.1%
-	12174	20.0%
1	9552	15.7%
9	2002	3.3%
3	1808	3.0%
5	1783	2.9%
8	1690	2.8%
6	1402	2.3%
7	1393	2.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	48696	80.0%
Dash Punctuation	12174	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	15050	30.9%
2	12827	26.3%
1	9552	19.6%
9	2002	4.1%
3	1808	3.7%
5	1783	3.7%
8	1690	3.5%
6	1402	2.9%
7	1393	2.9%
4	1189	2.4%

Dash Punctuation

Value	Count	Frequency (%)
-	12174	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	60870	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	15050	24.7%
2	12827	21.1%
-	12174	20.0%
1	9552	15.7%
9	2002	3.3%
3	1808	3.0%
5	1783	2.9%
8	1690	2.8%
6	1402	2.3%
7	1393	2.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	60870	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	15050	24.7%
2	12827	21.1%
-	12174	20.0%
1	9552	15.7%
9	2002	3.3%
3	1808	3.0%
5	1783	2.9%
8	1690	2.8%
6	1402	2.3%
7	1393	2.3%

action_price
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	805
Distinct (%)	73.9%
Missing	4998
Missing (%)	82.1%
Infinite	0
Infinite (%)	0.0%
Mean	103.73529

Minimum	0
Maximum	151.556
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	95.1 KiB

Quantile statistics

Minimum	0
5-th percentile	99.0024
Q1	100
median	102.101
Q3	105.616
95-th percentile	115.3734
Maximum	151.556
Range	151.556
Interquartile range (IQR)	5.616

Descriptive statistics

Standard deviation	7.3294175
Coefficient of variation (CV)	0.070655007
Kurtosis	45.268332
Mean	103.73529
Median Absolute Deviation (MAD)	2.101
Skewness	-1.4471795
Sum	112967.73
Variance	53.720361
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	221	3.6%
101	27	0.4%
102.75	5	0.1%
97.75	3	< 0.1%
102.875	3	< 0.1%
98	3	< 0.1%
104.253	2	< 0.1%
103.375	2	< 0.1%
100.5	2	< 0.1%
100.854	2	< 0.1%
Other values (795)	819	13.5%
(Missing)	4998	82.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
50.2595	1	< 0.1%
67.1	1	< 0.1%
79.261	1	< 0.1%
79.526	1	< 0.1%
85	1	< 0.1%
89.5	2	< 0.1%
91.688	1	< 0.1%
92.003	1	< 0.1%
92.016	1	< 0.1%

Value	Count	Frequency (%)
151.556	1	< 0.1%
147.153	1	< 0.1%
143.454	1	< 0.1%
141.172	1	< 0.1%
137.022	1	< 0.1%
136.585	1	< 0.1%
134.35	1	< 0.1%
132.757	1	< 0.1%
131.805	1	< 0.1%
131.638	1	< 0.1%

action_amount
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED

Distinct	734
Distinct (%)	54.7%
Missing	4746
Missing (%)	78.0%
Infinite	0
Infinite (%)	0.0%
Mean	692558.09

Minimum	0
Maximum	2.5 × 10⁸
Zeros	45
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	95.1 KiB

Quantile statistics

Minimum	0
5-th percentile	600.008
Q1	172550
median	400000
Q3	694992
95-th percentile	1500000
Maximum	2.5 × 10⁸
Range	2.5 × 10⁸
Interquartile range (IQR)	522442

Descriptive statistics

Standard deviation	6832317.1
Coefficient of variation (CV)	9.8653343
Kurtosis	1325.9439
Mean	692558.09
Median Absolute Deviation (MAD)	250000
Skewness	36.312222
Sum	9.287204 × 10⁸
Variance	4.6680557 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
500000	84	1.4%
750000	53	0.9%
1000000	50	0.8%
300000	46	0.8%
0	45	0.7%
400000	43	0.7%
250000	32	0.5%
350000	27	0.4%
1250000	26	0.4%
600000	24	0.4%
Other values (724)	911	15.0%
(Missing)	4746	78.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	45	0.7%
9.744	1	< 0.1%
10	1	< 0.1%
17	1	< 0.1%
20	1	< 0.1%
25	1	< 0.1%
30	1	< 0.1%
102	1	< 0.1%
173	1	< 0.1%
191	1	< 0.1%

Value	Count	Frequency (%)
250000000	1	< 0.1%
5385495	1	< 0.1%
4000000	1	< 0.1%
3843488	1	< 0.1%
3510199	1	< 0.1%
3190096	1	< 0.1%
3175908	1	< 0.1%
3000000	1	< 0.1%
2890467	1	< 0.1%
2850000	1	< 0.1%

amount_outstanding
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	633
Distinct (%)	10.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	560410.28

Minimum	0
Maximum	9518964
Zeros	2079
Zeros (%)	34.2%
Negative	0
Negative (%)	0.0%
Memory size	95.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	450000
Q3	800000
95-th percentile	1850707
Maximum	9518964
Range	9518964
Interquartile range (IQR)	800000

Descriptive statistics

Standard deviation	672732.7
Coefficient of variation (CV)	1.2004289
Kurtosis	10.911483
Mean	560410.28
Median Absolute Deviation (MAD)	450000
Skewness	2.3088767
Sum	3.4112174 × 10⁹
Variance	4.5256929 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2079	34.2%
500000	559	9.2%
1000000	427	7.0%
750000	338	5.6%
400000	218	3.6%
1250000	194	3.2%
600000	192	3.2%
1500000	186	3.1%
300000	169	2.8%
350000	111	1.8%
Other values (623)	1614	26.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2079	34.2%
379	1	< 0.1%
632	1	< 0.1%
727	1	< 0.1%
812	1	< 0.1%
1549	1	< 0.1%
2205	1	< 0.1%
2512	1	< 0.1%
2921	1	< 0.1%
3091	1	< 0.1%

Value	Count	Frequency (%)
9518964	1	< 0.1%
5500000	2	< 0.1%
5341555	1	< 0.1%
5000000	4	0.1%
4500000	1	< 0.1%
4250000	2	< 0.1%
4000000	5	0.1%
3960082	1	< 0.1%
3850000	1	< 0.1%
3797310	1	< 0.1%

greater_of
Boolean

CONSTANT MISSING

Distinct	1
Distinct (%)	0.1%
Missing	5322
Missing (%)	87.4%
Memory size	59.4 KiB

False	765
(Missing)	5322

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	765	12.6%
(Missing)	5322	87.4%

lesser_of
Boolean

CONSTANT MISSING

Distinct	1
Distinct (%)	0.1%
Missing	5322
Missing (%)	87.4%
Memory size	59.4 KiB

False	765
(Missing)	5322

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	765	12.6%
(Missing)	5322	87.4%

see_note
Boolean

HIGH CORRELATION IMBALANCE MISSING

Distinct	2
Distinct (%)	0.3%
Missing	5322
Missing (%)	87.4%
Memory size	59.4 KiB

False	764
True	1
(Missing)	5322

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	764	12.6%
True	1	< 0.1%
(Missing)	5322	87.4%

dated_date
Categorical

Distinct	1761
Distinct (%)	28.9%
Missing	0
Missing (%)	0.0%
Memory size	95.1 KiB

2017-05-11	18
2020-03-25	18
2019-08-15	16
2020-05-18	16
2019-01-15	15
Other values (1756)	6004

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	60870
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	469 ?
Unique (%)	7.7%

Sample

1st row	2012-02-13
2nd row	2012-02-13
3rd row	2012-02-13
4th row	2012-02-13
5th row	2012-02-10

Common Values

Value	Count	Frequency (%)
2017-05-11	18	0.3%
2020-03-25	18	0.3%
2019-08-15	16	0.3%
2020-05-18	16	0.3%
2019-01-15	15	0.2%
2020-05-11	15	0.2%
2020-04-01	15	0.2%
2019-05-15	15	0.2%
2017-02-09	15	0.2%
2020-03-27	15	0.2%
Other values (1751)	5929	97.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-05-11	18	0.3%
2020-03-25	18	0.3%
2019-08-15	16	0.3%
2020-05-18	16	0.3%
2019-01-15	15	0.2%
2020-05-11	15	0.2%
2020-04-01	15	0.2%
2019-05-15	15	0.2%
2017-02-09	15	0.2%
2020-03-27	15	0.2%
Other values (1751)	5929	97.4%

Most occurring characters

Value	Count	Frequency (%)
0	14489	23.8%
-	12174	20.0%
2	11663	19.2%
1	10380	17.1%
3	2138	3.5%
5	1952	3.2%
8	1773	2.9%
9	1756	2.9%
6	1611	2.6%
7	1480	2.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	48696	80.0%
Dash Punctuation	12174	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	14489	29.8%
2	11663	24.0%
1	10380	21.3%
3	2138	4.4%
5	1952	4.0%
8	1773	3.6%
9	1756	3.6%
6	1611	3.3%
7	1480	3.0%
4	1454	3.0%

Dash Punctuation

Value	Count	Frequency (%)
-	12174	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	60870	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	14489	23.8%
-	12174	20.0%
2	11663	19.2%
1	10380	17.1%
3	2138	3.5%
5	1952	3.2%
8	1773	2.9%
9	1756	2.9%
6	1611	2.6%
7	1480	2.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	60870	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	14489	23.8%
-	12174	20.0%
2	11663	19.2%
1	10380	17.1%
3	2138	3.5%
5	1952	3.2%
8	1773	2.9%
9	1756	2.9%
6	1611	2.6%
7	1480	2.4%

first_interest_date
Categorical

Distinct	1583
Distinct (%)	26.0%
Missing	0
Missing (%)	0.0%
Memory size	95.1 KiB

2020-10-15	49
2020-12-01	45
2021-02-15	42
2020-11-15	41
2020-11-01	39
Other values (1578)	5871

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	60870
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	669 ?
Unique (%)	11.0%

Sample

1st row	2012-08-13
2nd row	2012-08-15
3rd row	2012-08-15
4th row	2012-08-15
5th row	2012-08-15

Common Values

Value	Count	Frequency (%)
2020-10-15	49	0.8%
2020-12-01	45	0.7%
2021-02-15	42	0.7%
2020-11-15	41	0.7%
2020-11-01	39	0.6%
2020-12-15	39	0.6%
2021-03-15	39	0.6%
2020-10-01	38	0.6%
2020-02-15	35	0.6%
2022-03-15	34	0.6%
Other values (1573)	5686	93.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2020-10-15	49	0.8%
2020-12-01	45	0.7%
2021-02-15	42	0.7%
2020-11-15	41	0.7%
2020-11-01	39	0.6%
2020-12-15	39	0.6%
2021-03-15	39	0.6%
2020-10-01	38	0.6%
2020-02-15	35	0.6%
2019-09-15	34	0.6%
Other values (1573)	5686	93.4%

Most occurring characters

Value	Count	Frequency (%)
0	14263	23.4%
-	12174	20.0%
1	11923	19.6%
2	11265	18.5%
5	3271	5.4%
9	1662	2.7%
3	1495	2.5%
8	1303	2.1%
4	1203	2.0%
7	1160	1.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	48696	80.0%
Dash Punctuation	12174	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	14263	29.3%
1	11923	24.5%
2	11265	23.1%
5	3271	6.7%
9	1662	3.4%
3	1495	3.1%
8	1303	2.7%
4	1203	2.5%
7	1160	2.4%
6	1151	2.4%

Dash Punctuation

Value	Count	Frequency (%)
-	12174	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	60870	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	14263	23.4%
-	12174	20.0%
1	11923	19.6%
2	11265	18.5%
5	3271	5.4%
9	1662	2.7%
3	1495	2.5%
8	1303	2.1%
4	1203	2.0%
7	1160	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	60870	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	14263	23.4%
-	12174	20.0%
1	11923	19.6%
2	11265	18.5%
5	3271	5.4%
9	1662	2.7%
3	1495	2.5%
8	1303	2.1%
4	1203	2.0%
7	1160	1.9%

interest_frequency
Categorical

HIGH CORRELATION IMBALANCE

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	95.1 KiB

2.0	5583
4.0	500
12.0	2
1.0	2

Length

Max length	4
Median length	3
Mean length	3.0003286
Min length	3

Characters and Unicode

Total characters	18263
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2.0
2nd row	2.0
3rd row	2.0
4th row	2.0
5th row	2.0

Common Values

Value	Count	Frequency (%)
2.0	5583	91.7%
4.0	500	8.2%
12.0	2	< 0.1%
1.0	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2.0	5583	91.7%
4.0	500	8.2%
12.0	2	< 0.1%
1.0	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
.	6087	33.3%
0	6087	33.3%
2	5585	30.6%
4	500	2.7%
1	4	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	12176	66.7%
Other Punctuation	6087	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	6087	50.0%
2	5585	45.9%
4	500	4.1%
1	4	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
.	6087	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	18263	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	6087	33.3%
0	6087	33.3%
2	5585	30.6%
4	500	2.7%
1	4	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18263	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	6087	33.3%
0	6087	33.3%
2	5585	30.6%
4	500	2.7%
1	4	< 0.1%

coupon
Real number (ℝ)

Distinct	1236
Distinct (%)	20.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.1243181

Minimum	0.13925
Maximum	15
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	95.1 KiB

Quantile statistics

Minimum	0.13925
5-th percentile	0.955025
Q1	2.198
median	3.012
Q3	3.9
95-th percentile	5.625
Maximum	15
Range	14.86075
Interquartile range (IQR)	1.702

Descriptive statistics

Standard deviation	1.4319076
Coefficient of variation (CV)	0.45831044
Kurtosis	2.4004671
Mean	3.1243181
Median Absolute Deviation (MAD)	0.863
Skewness	0.87779548
Sum	19017.724
Variance	2.0503594
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.5	147	2.4%
4	119	2.0%
3.25	115	1.9%
3	109	1.8%
2.75	107	1.8%
2.5	98	1.6%
3.75	93	1.5%
2.25	91	1.5%
2	83	1.4%
3.375	82	1.3%
Other values (1226)	5043	82.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.13925	1	< 0.1%
0.2036	1	< 0.1%
0.2116	1	< 0.1%
0.218	1	< 0.1%
0.23285	1	< 0.1%
0.25	1	< 0.1%
0.2716	1	< 0.1%
0.28435	1	< 0.1%
0.3	1	< 0.1%
0.309	2	< 0.1%

Value	Count	Frequency (%)
15	1	< 0.1%
12.5	1	< 0.1%
10.125	1	< 0.1%
9.875	1	< 0.1%
9.75	4	0.1%
9.625	1	< 0.1%
9.5	4	0.1%
9.15	1	< 0.1%
9	1	< 0.1%
8.875	3	< 0.1%

pay_in_kind
Boolean

HIGH CORRELATION IMBALANCE MISSING

Distinct	2
Distinct (%)	0.1%
Missing	2502
Missing (%)	41.1%
Memory size	59.4 KiB

False	3584
True	1
(Missing)	2502

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	3584	58.9%
True	1	< 0.1%
(Missing)	2502	41.1%

coupon_change_indicator
Categorical

HIGH CORRELATION IMBALANCE

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	95.1 KiB

N	5240
F	502
CFFL	261
T	71
U	9
Other values (2)	4

Length

Max length	4
Median length	1
Mean length	1.1286348
Min length	1

Characters and Unicode

Total characters	6870
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	N
2nd row	N
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	5240	86.1%
F	502	8.2%
CFFL	261	4.3%
T	71	1.2%
U	9	0.1%
S	3	< 0.1%
R	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n	5240	86.1%
f	502	8.2%
cffl	261	4.3%
t	71	1.2%
u	9	0.1%
s	3	< 0.1%
r	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
N	5240	76.3%
F	1024	14.9%
C	261	3.8%
L	261	3.8%
T	71	1.0%
U	9	0.1%
S	3	< 0.1%
R	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	6870	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	5240	76.3%
F	1024	14.9%
C	261	3.8%
L	261	3.8%
T	71	1.0%
U	9	0.1%
S	3	< 0.1%
R	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6870	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	5240	76.3%
F	1024	14.9%
C	261	3.8%
L	261	3.8%
T	71	1.0%
U	9	0.1%
S	3	< 0.1%
R	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6870	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	5240	76.3%
F	1024	14.9%
C	261	3.8%
L	261	3.8%
T	71	1.0%
U	9	0.1%
S	3	< 0.1%
R	1	< 0.1%

day_count_basis
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	95.1 KiB

30/360	5591
ACT/360	496

Length

Max length	7
Median length	6
Mean length	6.0814851
Min length	6

Characters and Unicode

Total characters	37018
Distinct characters	7
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	30/360
2nd row	30/360
3rd row	30/360
4th row	30/360
5th row	30/360

Common Values

Value	Count	Frequency (%)
30/360	5591	91.9%
ACT/360	496	8.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
30/360	5591	91.9%
act/360	496	8.1%

Most occurring characters

Value	Count	Frequency (%)
3	11678	31.5%
0	11678	31.5%
/	6087	16.4%
6	6087	16.4%
A	496	1.3%
C	496	1.3%
T	496	1.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	29443	79.5%
Other Punctuation	6087	16.4%
Uppercase Letter	1488	4.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
3	11678	39.7%
0	11678	39.7%
6	6087	20.7%

Uppercase Letter

Value	Count	Frequency (%)
A	496	33.3%
C	496	33.3%
T	496	33.3%

Other Punctuation

Value	Count	Frequency (%)
/	6087	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	35530	96.0%
Latin	1488	4.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
3	11678	32.9%
0	11678	32.9%
/	6087	17.1%
6	6087	17.1%

Latin

Value	Count	Frequency (%)
A	496	33.3%
C	496	33.3%
T	496	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	37018	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
3	11678	31.5%
0	11678	31.5%
/	6087	16.4%
6	6087	16.4%
A	496	1.3%
C	496	1.3%
T	496	1.3%

last_interest_date
Categorical

Distinct	2515
Distinct (%)	41.3%
Missing	1
Missing (%)	< 0.1%
Memory size	95.1 KiB

2022-09-15	30
2030-09-15	28
2029-12-01	26
2022-03-15	24
2028-09-15	24
Other values (2510)	5954

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	60860
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1563 ?
Unique (%)	25.7%

Sample

1st row	2014-08-13
2nd row	2018-08-15
3rd row	2021-08-15
4th row	2016-08-15
5th row	2016-08-15

Common Values

Value	Count	Frequency (%)
2022-09-15	30	0.5%
2030-09-15	28	0.5%
2029-12-01	26	0.4%
2022-03-15	24	0.4%
2028-09-15	24	0.4%
2021-09-15	24	0.4%
2022-12-15	23	0.4%
2030-07-15	23	0.4%
2029-11-15	23	0.4%
2025-09-15	22	0.4%
Other values (2505)	5839	95.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2022-09-15	30	0.5%
2030-09-15	28	0.5%
2029-12-01	26	0.4%
2022-03-15	24	0.4%
2028-09-15	24	0.4%
2021-09-15	24	0.4%
2022-12-15	23	0.4%
2030-07-15	23	0.4%
2029-11-15	23	0.4%
2025-09-15	22	0.4%
Other values (2505)	5839	95.9%

Most occurring characters

Value	Count	Frequency (%)
0	13957	22.9%
2	13047	21.4%
-	12172	20.0%
1	8997	14.8%
5	3318	5.5%
3	2280	3.7%
9	1779	2.9%
4	1388	2.3%
8	1365	2.2%
7	1301	2.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	48688	80.0%
Dash Punctuation	12172	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	13957	28.7%
2	13047	26.8%
1	8997	18.5%
5	3318	6.8%
3	2280	4.7%
9	1779	3.7%
4	1388	2.9%
8	1365	2.8%
7	1301	2.7%
6	1256	2.6%

Dash Punctuation

Value	Count	Frequency (%)
-	12172	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	60860	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	13957	22.9%
2	13047	21.4%
-	12172	20.0%
1	8997	14.8%
5	3318	5.5%
3	2280	3.7%
9	1779	2.9%
4	1388	2.3%
8	1365	2.2%
7	1301	2.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	60860	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	13957	22.9%
2	13047	21.4%
-	12172	20.0%
1	8997	14.8%
5	3318	5.5%
3	2280	3.7%
9	1779	2.9%
4	1388	2.3%
8	1365	2.2%
7	1301	2.1%

years_to_maturity
Real number (ℝ)

Distinct	1128
Distinct (%)	18.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.8593783

Minimum	1.0054795
Maximum	30
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	95.1 KiB

Quantile statistics

Minimum	1.0054795
5-th percentile	3
Q1	5.0164384
median	7.1369863
Q3	10.041096
95-th percentile	15.032055
Maximum	30
Range	28.994521
Interquartile range (IQR)	5.0246575

Descriptive statistics

Standard deviation	4.3184731
Coefficient of variation (CV)	0.54946752
Kurtosis	4.5253807
Mean	7.8593783
Median Absolute Deviation (MAD)	2.890411
Skewness	1.5586303
Sum	47840.036
Variance	18.64921
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.021917808	174	2.9%
10.02739726	160	2.6%
10.02465753	156	2.6%
3.010958904	136	2.2%
5.010958904	133	2.2%
10.01369863	132	2.2%
10.01643836	130	2.1%
5.024657534	115	1.9%
10.01917808	114	1.9%
10.02191781	109	1.8%
Other values (1118)	4728	77.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.005479452	2	< 0.1%
1.008219178	1	< 0.1%
1.010958904	1	< 0.1%
1.016438356	1	< 0.1%
1.02739726	1	< 0.1%
1.147945205	1	< 0.1%
1.224657534	1	< 0.1%
1.320547945	1	< 0.1%
1.493150685	1	< 0.1%
1.495890411	2	< 0.1%

Value	Count	Frequency (%)
30	1	< 0.1%
29.99726027	1	< 0.1%
29.99452055	2	< 0.1%
29.99178082	2	< 0.1%
29.9890411	1	< 0.1%
29.97534247	1	< 0.1%
29.96164384	1	< 0.1%
29.95068493	1	< 0.1%
29.94246575	1	< 0.1%
29.93424658	1	< 0.1%

Auto

Heatmap
Table

	issue_id	issuer_id	gross_spread	selling_concession	offering_amt	offering_price	offering_yield	principal_amt	action_price	action_amount	amount_outstanding	coupon	years_to_maturity	security_level	enhancement	coupon_type	mtn	yankee	canadian	settlement_type	comp_neg_exch_deal	rule_415_reg	sec_reg_type1	denomination	covenants	defeased	defaulted	tender_exch_offer	redeemable	refund_protection	overallotment_opt	announced_call	active_issue	dep_eligibility	subsequent_data	fungible	action_type	see_note	interest_frequency	pay_in_kind	coupon_change_indicator	day_count_basis
issue_id	1.000	0.110	0.060	0.091	0.081	0.014	-0.111	0.061	0.070	0.038	0.538	-0.039	0.118	0.041	0.060	0.123	0.017	0.055	0.072	0.022	0.295	0.799	0.121	0.043	0.128	0.014	0.000	0.202	0.226	0.026	0.000	0.036	0.578	0.074	0.356	0.374	0.213	0.000	0.115	0.706	0.121	0.197
issuer_id	0.110	1.000	0.047	0.083	0.030	0.029	0.101	0.018	0.007	0.107	0.065	0.091	0.016	0.056	0.244	0.143	0.000	0.245	0.132	0.000	0.139	0.078	0.085	0.130	0.092	0.000	0.000	0.090	0.144	0.000	0.000	0.000	0.142	0.000	0.103	0.113	0.079	0.000	0.041	0.077	0.099	0.073
gross_spread	0.060	0.047	1.000	0.962	-0.324	-0.285	0.521	-0.065	0.252	-0.324	0.116	0.550	0.656	0.107	0.134	0.335	0.050	0.318	0.081	0.000	0.000	0.121	0.134	0.112	0.121	0.000	0.000	0.104	0.318	0.000	0.218	0.060	0.372	0.050	0.000	0.053	0.195	0.000	0.195	0.000	0.168	0.342
selling_concession	0.091	0.083	0.962	1.000	-0.309	-0.386	0.496	-0.027	0.293	-0.328	0.164	0.534	0.673	0.129	0.000	0.324	0.091	0.198	0.072	0.000	0.000	0.119	0.170	0.099	0.008	0.000	0.000	0.102	0.273	0.000	0.999	0.000	0.295	0.000	0.006	0.007	0.155	0.000	0.174	0.000	0.155	0.299
offering_amt	0.081	0.030	-0.324	-0.309	1.000	0.093	-0.123	0.050	0.006	0.484	0.439	-0.099	-0.024	0.009	0.051	0.052	0.000	0.159	0.000	0.000	0.054	0.044	0.081	0.067	0.113	0.000	0.000	0.105	0.000	0.000	0.000	0.000	0.062	0.000	0.089	0.083	0.047	0.050	0.050	0.000	0.090	0.100
offering_price	0.014	0.029	-0.285	-0.386	0.093	1.000	-0.071	0.047	-0.181	0.145	-0.081	-0.191	-0.353	0.000	0.168	0.100	0.000	0.056	0.011	0.000	0.995	0.129	0.504	0.073	0.025	0.000	0.000	0.065	0.051	0.000	0.000	0.000	0.101	0.000	0.000	0.174	0.109	0.000	0.058	0.000	0.074	0.083
offering_yield	-0.111	0.101	0.521	0.496	-0.123	-0.071	1.000	-0.017	0.429	-0.205	0.104	0.996	0.439	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.103	0.000	0.000	0.000	0.000	0.023	0.000	0.000	0.000	0.000	0.000	0.012	0.000	0.000	1.000	0.000	0.000	0.000	0.000
principal_amt	0.061	0.018	-0.065	-0.027	0.050	0.047	-0.017	1.000	0.049	-0.028	0.064	-0.018	-0.031	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.009	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	1.000	0.000	1.000	0.000	0.000
action_price	0.070	0.007	0.252	0.293	0.006	-0.181	0.429	0.049	1.000	-0.184	0.183	0.472	0.352	0.000	0.052	0.099	1.000	0.087	0.000	0.000	0.275	0.068	0.097	0.000	0.000	1.000	1.000	0.297	0.000	1.000	1.000	0.000	0.297	0.050	0.062	0.149	0.437	1.000	0.076	1.000	0.000	0.072
action_amount	0.038	0.107	-0.324	-0.328	0.484	0.145	-0.205	-0.028	-0.184	1.000	-0.324	-0.250	-0.303	0.000	0.000	0.053	1.000	0.026	0.000	0.000	0.000	0.000	0.102	0.153	0.000	1.000	1.000	0.000	0.000	1.000	0.000	0.093	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.259	0.000
amount_outstanding	0.538	0.065	0.116	0.164	0.439	-0.081	0.104	0.064	0.183	-0.324	1.000	0.162	0.413	0.032	0.054	0.113	0.000	0.133	0.000	0.000	0.076	0.086	0.100	0.083	0.078	0.000	0.000	0.132	0.067	0.000	0.000	0.000	0.382	0.000	0.068	0.076	0.166	0.051	0.075	0.000	0.131	0.132
coupon	-0.039	0.091	0.550	0.534	-0.099	-0.191	0.996	-0.018	0.472	-0.250	0.162	1.000	0.490	0.073	0.147	0.262	0.000	0.046	0.138	0.000	0.379	0.188	0.121	0.026	0.079	0.000	0.000	0.212	0.190	0.000	0.053	0.000	0.283	0.000	0.056	0.113	0.174	0.035	0.182	0.000	0.141	0.326
years_to_maturity	0.118	0.016	0.656	0.673	-0.024	-0.353	0.439	-0.031	0.352	-0.303	0.413	0.490	1.000	0.158	0.076	0.328	0.000	0.135	0.106	0.000	0.412	0.135	0.118	0.049	0.071	0.000	0.000	0.135	0.317	0.000	0.000	0.000	0.553	0.000	0.048	0.096	0.221	0.223	0.234	0.000	0.183	0.409
security_level	0.041	0.056	0.107	0.129	0.009	0.000	0.000	0.000	0.000	0.000	0.032	0.073	0.158	1.000	0.094	0.172	0.000	0.091	0.097	0.000	0.000	0.039	0.104	0.077	0.040	0.000	0.000	0.062	0.013	0.000	0.046	0.000	0.096	0.000	0.000	0.015	0.065	0.110	0.000	0.000	0.242	0.034
enhancement	0.060	0.244	0.134	0.000	0.051	0.168	0.000	0.000	0.052	0.000	0.054	0.147	0.076	0.094	1.000	0.083	0.000	0.183	0.015	0.000	0.153	0.021	0.176	0.176	0.026	0.000	0.000	0.055	0.031	0.000	0.000	0.027	0.027	0.033	0.000	0.000	0.088	0.000	0.020	0.000	0.109	0.019
coupon_type	0.123	0.143	0.335	0.324	0.052	0.100	0.000	0.000	0.099	0.053	0.113	0.262	0.328	0.172	0.083	1.000	0.000	0.144	0.022	0.000	0.055	0.065	0.144	0.229	0.030	0.000	0.000	0.087	0.368	0.000	0.000	0.000	0.171	0.000	0.015	0.038	0.269	0.000	0.774	0.000	1.000	0.772
mtn	0.017	0.000	0.050	0.091	0.000	0.000	0.000	0.000	1.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	1.000	0.000	1.000	0.000	0.000
yankee	0.055	0.245	0.318	0.198	0.159	0.056	0.000	0.000	0.087	0.026	0.133	0.046	0.135	0.091	0.183	0.144	0.000	1.000	0.058	0.000	0.043	0.023	0.580	0.562	0.194	0.000	0.000	0.000	0.159	0.000	0.017	0.046	0.044	0.000	0.000	0.072	0.122	0.000	0.069	0.000	0.159	0.065
canadian	0.072	0.132	0.081	0.072	0.000	0.011	0.000	0.000	0.000	0.000	0.000	0.138	0.106	0.097	0.015	0.022	0.000	0.058	1.000	0.000	0.020	0.042	0.565	0.118	0.008	0.000	0.000	0.005	0.046	0.000	0.000	0.000	0.042	0.000	0.010	0.047	0.066	0.093	0.033	0.000	0.028	0.035
settlement_type	0.022	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.008	0.000	0.000	0.000	0.010	0.000	0.007	0.000	0.000	0.000	0.000	0.000	0.000	0.000
comp_neg_exch_deal	0.295	0.139	0.000	0.000	0.054	0.995	1.000	0.000	0.275	0.000	0.076	0.379	0.412	0.000	0.153	0.055	0.000	0.043	0.020	0.000	1.000	0.191	0.720	0.119	0.000	0.000	0.000	0.097	0.000	0.000	0.000	0.000	0.054	0.037	0.000	0.153	0.130	0.000	0.047	0.000	0.055	0.048
rule_415_reg	0.799	0.078	0.121	0.119	0.044	0.129	0.000	0.000	0.068	0.000	0.086	0.188	0.135	0.039	0.021	0.065	0.000	0.023	0.042	0.000	0.191	1.000	0.172	0.081	0.104	0.000	0.000	0.095	0.174	0.000	0.000	0.000	0.159	0.042	0.187	0.044	0.188	0.000	0.138	0.000	0.161	0.141
sec_reg_type1	0.121	0.085	0.134	0.170	0.081	0.504	0.000	0.009	0.097	0.102	0.100	0.121	0.118	0.104	0.176	0.144	0.000	0.580	0.565	0.000	0.720	0.172	1.000	0.174	0.161	0.000	0.000	0.106	0.167	0.000	0.000	0.060	0.147	0.028	0.039	0.159	0.071	0.000	0.028	0.000	0.069	0.067
denomination	0.043	0.130	0.112	0.099	0.067	0.073	0.103	0.000	0.000	0.153	0.083	0.026	0.049	0.077	0.176	0.229	0.000	0.562	0.118	0.000	0.119	0.081	0.174	1.000	0.279	0.000	0.000	0.065	0.231	0.013	0.050	0.041	0.091	0.000	0.000	0.103	0.044	0.000	0.050	0.000	0.116	0.083
covenants	0.128	0.092	0.121	0.008	0.113	0.025	0.000	0.000	0.000	0.000	0.078	0.079	0.071	0.040	0.026	0.030	0.000	0.194	0.008	0.000	0.000	0.104	0.161	0.279	1.000	0.000	0.000	0.000	0.232	0.000	0.000	0.000	0.042	0.036	0.091	0.028	0.084	0.073	0.053	0.000	0.078	0.024
defeased	0.014	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	1.000	0.000	1.000	0.000	0.000
defaulted	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000
tender_exch_offer	0.202	0.090	0.104	0.102	0.105	0.065	0.000	0.000	0.297	0.000	0.132	0.212	0.135	0.062	0.055	0.087	0.000	0.000	0.005	0.000	0.097	0.095	0.106	0.065	0.000	0.000	0.000	1.000	0.052	0.000	0.000	0.022	0.104	0.000	0.000	0.084	0.774	0.000	0.040	0.000	0.115	0.046
redeemable	0.226	0.144	0.318	0.273	0.000	0.051	0.023	0.000	0.000	0.000	0.067	0.190	0.317	0.013	0.031	0.368	0.000	0.159	0.046	0.008	0.000	0.174	0.167	0.231	0.232	0.000	0.000	0.052	1.000	0.000	0.000	0.014	0.266	0.026	0.056	0.013	0.409	0.000	0.490	0.000	0.500	0.494
refund_protection	0.026	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.013	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	1.000	0.000	1.000	0.000	0.000
overallotment_opt	0.000	0.000	0.218	0.999	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.053	0.000	0.046	0.000	0.000	0.000	0.017	0.000	0.000	0.000	0.000	0.000	0.050	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.000	0.576	0.000	0.042	0.000	0.007	0.000
announced_call	0.036	0.000	0.060	0.000	0.000	0.000	0.000	0.000	0.000	0.093	0.000	0.000	0.000	0.000	0.027	0.000	0.000	0.046	0.000	0.000	0.000	0.000	0.060	0.041	0.000	0.000	0.000	0.022	0.014	0.000	0.000	1.000	0.065	0.000	0.016	0.000	0.177	0.000	0.000	0.000	0.000	0.000
active_issue	0.578	0.142	0.372	0.295	0.062	0.101	0.000	0.000	0.297	0.000	0.382	0.283	0.553	0.096	0.027	0.171	0.000	0.044	0.042	0.010	0.054	0.159	0.147	0.091	0.042	0.000	0.000	0.104	0.266	0.000	0.000	0.065	1.000	0.038	0.000	0.077	0.997	0.000	0.311	0.000	0.340	0.310
dep_eligibility	0.074	0.000	0.050	0.000	0.000	0.000	0.000	0.000	0.050	0.000	0.000	0.000	0.000	0.000	0.033	0.000	0.000	0.000	0.000	0.000	0.037	0.042	0.028	0.000	0.036	0.000	0.000	0.000	0.026	0.000	0.000	0.000	0.038	1.000	0.047	0.047	0.036	0.000	0.000	0.000	0.000	0.000
subsequent_data	0.356	0.103	0.000	0.006	0.089	0.000	0.012	1.000	0.062	0.000	0.068	0.056	0.048	0.000	0.000	0.015	1.000	0.000	0.010	0.007	0.000	0.187	0.039	0.000	0.091	1.000	0.000	0.000	0.056	1.000	0.000	0.016	0.000	0.047	1.000	0.142	0.031	0.000	0.000	1.000	0.043	0.000
fungible	0.374	0.113	0.053	0.007	0.083	0.174	0.000	0.000	0.149	0.000	0.076	0.113	0.096	0.015	0.000	0.038	0.000	0.072	0.047	0.000	0.153	0.044	0.159	0.103	0.028	0.000	0.000	0.084	0.013	0.000	0.000	0.000	0.077	0.047	0.142	1.000	0.140	0.000	0.000	0.000	0.063	0.000
action_type	0.213	0.079	0.195	0.155	0.047	0.109	0.000	0.000	0.437	0.000	0.166	0.174	0.221	0.065	0.088	0.269	0.000	0.122	0.066	0.000	0.130	0.188	0.071	0.044	0.084	0.000	0.000	0.774	0.409	0.000	0.576	0.177	0.997	0.036	0.031	0.140	1.000	0.000	0.227	0.100	0.180	0.397
see_note	0.000	0.000	0.000	0.000	0.050	0.000	1.000	1.000	1.000	1.000	0.051	0.035	0.223	0.110	0.000	0.000	1.000	0.000	0.093	0.000	0.000	0.000	0.000	0.000	0.073	1.000	1.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	1.000	0.000	0.000
interest_frequency	0.115	0.041	0.195	0.174	0.050	0.058	0.000	0.000	0.076	0.000	0.075	0.182	0.234	0.000	0.020	0.774	0.000	0.069	0.033	0.000	0.047	0.138	0.028	0.050	0.053	0.000	0.000	0.040	0.490	0.000	0.042	0.000	0.311	0.000	0.000	0.000	0.227	0.000	1.000	0.000	0.566	0.970
pay_in_kind	0.706	0.077	0.000	0.000	0.000	0.000	0.000	1.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000	1.000	0.000	0.100	1.000	0.000	1.000	0.000	0.000
coupon_change_indicator	0.121	0.099	0.168	0.155	0.090	0.074	0.000	0.000	0.000	0.259	0.131	0.141	0.183	0.242	0.109	1.000	0.000	0.159	0.028	0.000	0.055	0.161	0.069	0.116	0.078	0.000	0.000	0.115	0.500	0.000	0.007	0.000	0.340	0.000	0.043	0.063	0.180	0.000	0.566	0.000	1.000	0.982
day_count_basis	0.197	0.073	0.342	0.299	0.100	0.083	0.000	0.000	0.072	0.000	0.132	0.326	0.409	0.034	0.019	0.772	0.000	0.065	0.035	0.000	0.048	0.141	0.067	0.083	0.024	0.000	0.000	0.046	0.494	0.000	0.000	0.000	0.310	0.000	0.000	0.000	0.397	0.000	0.970	0.000	0.982	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	issue_id	issuer_id	prospectus_issuer_name	issuer_cusip	issue_cusip	issue_name	maturity	security_level	enhancement	coupon_type	mtn	asset_backed	yankee	canadian	oid	slob	issue_offered_global	settlement_type	gross_spread	selling_concession	comp_neg_exch_deal	rule_415_reg	sec_reg_type1	offering_amt	offering_date	offering_price	offering_yield	delivery_date	unit_deal	form_of_own	denomination	principal_amt	covenants	defeased	defaulted	tender_exch_offer	redeemable	refund_protection	overallotment_opt	announced_call	active_issue	dep_eligibility	bond_type	subsequent_data	isin	fungible	complete_cusip	action_type	effective_date	action_price	action_amount	greater_of	lesser_of	see_note	dated_date	first_interest_date	interest_frequency	coupon	pay_in_kind	coupon_change_indicator	day_count_basis	last_interest_date	years_to_maturity
291018	570539.0	39095.0	AT&T INC	00206R	BB7	GLOBAL NT	2015-02-13	SEN	N	F	N	N	N	N	N	N	Y	S	2.50	1.5	NEG	N	RBNA	1000000.0	2012-02-08	99.929	0.89904	2012-02-13	N	BE	2/1	1000.0	Y	N	N	N	Y	N	N	N	N	DCE	CDEB	Y	US00206RBB78	N	00206RBB7	E	2014-07-15	100.40872	1000000.0	NaN	NaN	NaN	2012-02-13	2012-08-13	2.0	0.875	N	N	30/360	2014-08-13	3.016438
291032	570533.0	4003.0	SYNOVUS FINL CORP	87161C	AJ4	GLOBAL SR NT	2019-02-15	SEN	N	F	N	N	N	N	N	N	Y	S	13.75	7.0	NEG	Y	RBNA	300000.0	2012-02-08	99.339	8.00024	2012-02-13	N	BE	2/1	1000.0	Y	N	N	N	Y	N	N	N	N	DCE	CDEB	Y	US87161CAJ45	Y	87161CAJ4	E	2017-11-09	107.26500	300000.0	NaN	NaN	NaN	2012-02-13	2012-08-15	2.0	7.875	N	N	30/360	2018-08-15	7.024658
291034	570535.0	40357.0	BMC SOFTWARE INC	055921	AB6	GLOBAL SR NT	2022-02-15	SEN	N	F	N	N	N	N	N	N	Y	S	6.50	4.0	NEG	Y	S-3	500000.0	2012-02-08	99.468	4.31607	2012-02-13	N	BE	2/1	1000.0	Y	N	N	Y	Y	N	N	N	N	DCE	CDEB	Y	US055921AB64	Y	055921AB6	B	2018-11-01	103.18500	46181.0	NaN	NaN	NaN	2012-02-13	2012-08-15	2.0	4.250	N	N	30/360	2021-08-15	10.027397
291043	570547.0	39095.0	AT&T INC	00206R	BC5	GLOBAL NT	2017-02-15	SEN	N	F	N	N	N	N	N	N	Y	S	3.50	2.0	NEG	N	RBNA	1000000.0	2012-02-08	99.880	1.62507	2012-02-13	N	BE	2/1	1000.0	Y	N	N	N	Y	N	N	N	N	DCE	CDEB	Y	US00206RBC51	N	00206RBC5	IM	2017-02-15	NaN	NaN	NaN	NaN	NaN	2012-02-13	2012-08-15	2.0	1.600	N	N	30/360	2016-08-15	5.024658
291045	570549.0	33631.0	AFLAC INC	001055	AH5	GLOBAL SR NT	2017-02-15	SEN	N	F	N	N	N	N	N	N	Y	S	6.00	3.5	NEG	Y	RBNA	400000.0	2012-02-08	99.911	2.66914	2012-02-10	N	BE	2/1	1000.0	Y	N	N	N	Y	N	N	N	N	DCE	CDEB	Y	US001055AH52	Y	001055AH5	IM	2017-02-15	NaN	NaN	NaN	NaN	NaN	2012-02-10	2012-08-15	2.0	2.650	N	N	30/360	2016-08-15	5.024658
291046	570551.0	33631.0	AFLAC INC	001055	AJ1	GLOBAL SR NT	2022-02-15	SEN	N	F	N	N	N	N	N	N	Y	S	6.50	4.0	NEG	Y	RBNA	350000.0	2012-02-08	99.820	4.02208	2012-02-10	N	BE	2/1	1000.0	Y	N	N	N	Y	N	N	N	N	DCE	CDEB	Y	US001055AJ19	Y	001055AJ1	E	2020-01-10	104.25700	350000.0	NaN	NaN	NaN	2012-02-10	2012-08-15	2.0	4.000	N	N	30/360	2021-08-15	10.027397
291048	570553.0	39095.0	AT&T INC	00206R	BD3	GLOBAL NT	2022-02-15	SEN	N	F	N	N	N	N	N	N	Y	S	4.50	3.0	NEG	N	RBNA	1000000.0	2012-02-08	99.803	3.02298	2012-02-13	N	BE	2/1	1000.0	Y	N	N	Y	Y	N	N	N	N	DCE	CDEB	Y	US00206RBD35	Y	00206RBD3	B	2020-07-23	NaN	1456834.0	NaN	NaN	NaN	2012-02-13	2012-08-15	2.0	3.000	N	N	30/360	2021-08-15	10.027397
291068	570577.0	36599.0	KENNAMETAL INC	489170	AC4	GLOBAL SR NT	2022-02-15	SEN	N	F	N	N	N	N	N	N	Y	S	6.50	4.0	NEG	Y	S-3	300000.0	2012-02-09	99.877	3.88997	2012-02-14	N	BE	2/1	1000.0	Y	N	N	N	Y	N	N	N	N	DCE	CDEB	Y	US489170AC47	Y	489170AC4	B	2021-03-12	100.00000	300000.0	NaN	NaN	NaN	2012-02-14	2012-08-15	2.0	3.875	N	N	30/360	2021-08-15	10.024658
291071	570581.0	1689.0	FREEPORT MCMORAN COPPER & GOLD INC	35671D	AV7	GLOBAL SR NT	2015-02-13	SEN	N	F	N	N	N	N	N	N	Y	S	4.50	3.0	NEG	N	RBNA	500000.0	2012-02-08	99.857	1.44888	2012-02-13	N	BE	2/1	1000.0	Y	N	N	N	Y	N	N	N	N	DCE	CDEB	Y	US35671DAV73	Y	35671DAV7	E	2014-12-17	100.17900	500000.0	NaN	NaN	NaN	2012-02-13	2012-08-13	2.0	1.400	N	N	30/360	2014-08-13	3.016438
291076	570587.0	1689.0	FREEPORT MCMORAN COPPER & GOLD INC	35671D	AW5	GLOBAL SR NT	2017-03-01	SEN	N	F	N	N	N	N	N	N	Y	S	6.00	3.5	NEG	N	RBNA	500000.0	2012-02-08	99.880	2.17536	2012-02-13	N	BE	2/1	1000.0	Y	N	N	N	Y	N	N	N	N	DCE	CDEB	Y	US35671DAW56	Y	35671DAW5	IM	2017-03-01	NaN	NaN	NaN	NaN	NaN	2012-02-13	2012-09-01	2.0	2.150	N	N	30/360	2016-09-01	5.063014

	issue_id	issuer_id	prospectus_issuer_name	issuer_cusip	issue_cusip	issue_name	maturity	security_level	enhancement	coupon_type	mtn	asset_backed	yankee	canadian	oid	slob	issue_offered_global	settlement_type	gross_spread	selling_concession	comp_neg_exch_deal	rule_415_reg	sec_reg_type1	offering_amt	offering_date	offering_price	offering_yield	delivery_date	unit_deal	form_of_own	denomination	principal_amt	covenants	defeased	defaulted	tender_exch_offer	redeemable	refund_protection	overallotment_opt	announced_call	active_issue	dep_eligibility	bond_type	subsequent_data	isin	fungible	complete_cusip	action_type	effective_date	action_price	action_amount	amount_outstanding	greater_of	lesser_of	see_note	dated_date	first_interest_date	interest_frequency	coupon	pay_in_kind	coupon_change_indicator	day_count_basis	last_interest_date	years_to_maturity
560106	1040686.0	41829.0	NEXTERA ENERGY CAP HLDGS INC	65339K	CJ7	GLOBAL GTD DEB	2032-07-15	SEN	Y	F	N	N	N	N	N	N	Y	S	6.5	4.0	NEG	Y	RBNA	1000000.0	2022-06-21	99.925	5.01012	2022-06-23	N	BE	2/1	1000.0	Y	N	N	N	Y	N	N	N	Y	DCE	CDEB	NaN	US65339KCJ79	Y	65339KCJ7	I	2022-06-23	NaN	NaN	1000000.0	NaN	NaN	NaN	2022-06-23	2023-01-15	2.0	5.000	NaN	N	30/360	2032-01-15	10.073973
560242	1040832.0	51560.0	TARGA RES CORP	87612K	AA0	GTD GLOBAL SR NT	2027-07-01	SEN	Y	F	N	N	N	N	N	N	Y	S	6.0	3.5	NEG	Y	S-3	750000.0	2022-06-22	99.849	5.23457	2022-07-07	N	BE	2/1	1000.0	Y	N	N	N	Y	N	N	N	Y	DCE	CDEB	NaN	US87612KAA07	Y	87612KAA0	I	2022-07-07	NaN	NaN	750000.0	NaN	NaN	NaN	2022-07-07	2023-01-01	2.0	5.200	NaN	N	30/360	2027-01-01	5.027397
560270	1040864.0	33549.0	KREDITANSTALT FUR WIEDERAUFBAU	500769	JU9	GTD GLOBAL NT	2025-06-10	SEN	Y	F	N	N	Y	N	N	N	Y	S	1.0	NaN	NEG	Y	RBNA	3000000.0	2022-06-23	99.990	3.12815	2022-06-30	N	BE	1/1	1000.0	N	N	N	N	N	N	N	N	Y	DCE	CDEB	NaN	US500769JU96	N	500769JU9	I	2022-06-30	NaN	NaN	3000000.0	NaN	NaN	NaN	2022-06-30	2022-12-10	2.0	3.125	NaN	N	30/360	2024-12-10	2.967123
560338	1040939.0	46387.0	EVERSOURCE ENERGY	30040W	AR9	GLOBAL SR NT SER Y	2027-07-01	SEN	N	F	N	N	N	N	N	N	Y	S	6.0	3.5	NEG	Y	RBNA	600000.0	2022-06-22	99.880	4.62724	2022-06-27	N	BE	2/1	1000.0	Y	N	N	N	Y	N	N	N	Y	DCE	CDEB	NaN	US30040WAR97	Y	30040WAR9	I	2022-06-27	NaN	NaN	600000.0	NaN	NaN	NaN	2022-06-27	2023-01-01	2.0	4.600	NaN	N	30/360	2027-01-01	5.027397
560341	1040942.0	46387.0	EVERSOURCE ENERGY	30040W	AS7	GLOBAL SR NT SER X	2024-06-27	SEN	N	F	N	N	N	N	N	N	Y	S	2.5	1.5	NEG	Y	RBNA	900000.0	2022-06-22	99.964	4.21896	2022-06-27	N	BE	2/1	1000.0	Y	N	N	N	Y	N	N	N	Y	DCE	CDEB	NaN	US30040WAS70	Y	30040WAS7	I	2022-06-27	NaN	NaN	900000.0	NaN	NaN	NaN	2022-06-27	2022-12-27	2.0	4.200	NaN	N	30/360	2023-12-27	2.016438
560342	1040943.0	40313.0	KLA TENCOR CORP	482480	AL4	GLOBAL SR NT	2032-07-15	SEN	N	F	N	N	N	N	N	N	Y	S	4.5	2.5	NEG	Y	S-3	1000000.0	2022-06-21	99.941	4.65787	2022-06-23	N	BE	2/1	1000.0	Y	N	N	N	Y	N	N	N	Y	DCE	CDEB	NaN	US482480AL46	Y	482480AL4	I	2022-06-23	NaN	NaN	1000000.0	NaN	NaN	NaN	2022-06-23	2023-01-15	2.0	4.650	NaN	N	30/360	2032-01-15	10.073973
560518	1041125.0	40252.0	BIOGEN INC	09062X	AK9	GLOBAL SR NT	2051-02-15	SEN	N	F	N	N	N	N	N	N	Y	S	NaN	NaN	EXCH	Y	RBNA	700705.0	2022-06-28	0.000	NaN	2022-06-28	N	BE	2/1	1000.0	Y	N	N	N	Y	N	N	N	Y	DCE	CDEB	NaN	US09062XAK90	N	09062XAK9	I	2022-06-28	NaN	NaN	700705.0	NaN	NaN	NaN	2022-02-15	2022-08-15	2.0	3.250	NaN	N	30/360	2050-08-15	28.654795
561172	1042545.0	41081.0	NOMURA HLDGS INC	65535H	BE8	GLOBAL SR NT	2025-07-03	SEN	N	F	N	N	Y	N	N	N	Y	S	2.5	NaN	NEG	Y	F-3	800000.0	2022-06-28	100.000	5.09900	2022-07-06	N	BE	200/1	1000.0	Y	N	N	N	Y	N	N	N	Y	DCE	CDEB	NaN	US65535HBE80	Y	65535HBE8	I	2022-07-06	NaN	NaN	800000.0	NaN	NaN	NaN	2022-07-06	2023-01-03	2.0	5.099	NaN	N	30/360	2025-01-03	3.016438
561173	1042546.0	41081.0	NOMURA HLDGS INC	GLOBAL	BF5	GLOBAL SR NT	2027-07-06	SEN	N	F	N	N	Y	N	N	N	Y	S	3.5	NaN	NEG	Y	F-3	500000.0	2022-06-28	100.000	5.38600	2022-07-06	N	BE	200/1	1000.0	Y	N	N	N	Y	N	N	N	Y	DCE	CDEB	NaN	US65535HBF55	Y	GLOBALBF5	I	2022-07-06	NaN	NaN	500000.0	NaN	NaN	NaN	2022-07-06	2023-01-06	2.0	5.386	NaN	N	30/360	2027-01-06	5.024658
561174	1042547.0	41081.0	NOMURA HLDGS INC	65535H	BC2	GLOBAL SR NT	2029-07-06	SEN	N	F	N	N	Y	N	N	N	Y	S	4.0	NaN	NEG	Y	F-3	600000.0	2022-06-28	100.000	5.60500	2022-07-06	N	BE	200/1	1000.0	Y	N	N	N	Y	N	N	N	Y	DCE	CDEB	NaN	US65535HBC25	Y	65535HBC2	I	2022-07-06	NaN	NaN	600000.0	NaN	NaN	NaN	2022-07-06	2023-01-06	2.0	5.605	NaN	N	30/360	2029-01-06	7.027397

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)